"Matt Wlazlo" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> I'm noticing some strange behavior while calculating prices on my invoice. > > A1=39:50 (hours worked) > A2=A1*24 (==39.83) > A3=65 (rate) > A4=A3*A2 > > Now A4 will equal 2589.17. But, somewhere else in the spreadsheet, > typing =39.83*65 gives 2588.95! > > Does anyone know what I'm doing wrong? I'm using Ooo 2.0 on windows. I think you'll find it is a rounding issue. If you change the format of A2 so that you see more decimals, you'll see that it is really 39.833333 (recurring, I presume). Multiply *that* by 65 and you'll get 2589.17. -- Bob Long --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
