currency addition results inaccurate

  • Thread starter Thread starter kgs
  • Start date Start date
K

kgs

Please help,

I'm trying to add currencies that were the result of hours multiplied by
rate but the sum is not comimg out quite accurate. Eg:
hour rate total
8:10 $7.50 $61.25
8:45 $7.50 $65.63
4:05 $7.50 $30.63
7:25 $7.50 $55.63
10:09 $7.50 $76.13
2:58 $7.50 $22.25
7:25 $7.50 $55.63
10:09 $7.50 $76.13
2:58 $7.50 $22.25
$465.50

function for hour :=+(C4-B4)-D4 (which is the result of previous calculation
not shown)
no function for rate cells - just number put into cell
function used for total: =PRODUCT(E4:F4)*24 (where E4 is hour and F4 is
rate)

As you can see the column for total is incorrect and I can't seem to remedy
this.

Thanks in advance
Geo.
 
Great! It works, thank you very much.
Geo
Alan said:
Its because $61.25 is probably something like $61.2455741 formatted to show
two decimal places, ie $61.25 but the real value is still $61.2455741
use =ROUNDUP(your formula,2) or
=ROUNDDOWN(your formula,2)
This will remove the extra decimal paces, leaving only two and enable the
column to sum correctly,
Regards,
Click to expand...
 
Format as General, all values in the total column. Assuming that the
values in the hour column do not have undisplayed seconds. then the
values shown with .63 cents are really .625, and $76.13 is really
76.125. Since the actual values are short of the displayed values by
0.005 on 6, values, the grand total is short of the sum of displayed
values by 0.03

Which answer is correct depends on your billing policies. Round at the
appropriate point to give consistent results.

Jerry
 
Back
Top