Rounding error

Hi everyone. I may my cells formatted to accounting 2 decimal places. 29.93 is entered as 29.295. the cell that says 70.70 is the sum of 29.93 and 40.78. Why is it showing 70.70 instead of 70.71? thanks

05/16/17 qqw $29.93 $29.93
qwq $29.93 $10.85 $40.78 $70.70

my bad, .925 is correct.

40.78 is =SUM(D105:F105) which is $29.93 + $10.85

yea, when i hard code 40.78 is fixes it. what do i need to do to fix it formula wise? thanks

Originally Posted by lemonbug

yea, when i hard code 40.78 is fixes it. what do i need to do to fix it formula wise? thanks

It depends what you mean by "fix".
If you want to round the sum to 2 decimal places (i.e. change 40.775 to 40.78), you can change your sum formula to =ROUND(SUM(D105:F105),2)

yea that works thanks. I just need the total to be 70.71 instead of 70.71 for accounting purposes. Thanks!

Originally Posted by lemonbug

yea that works thanks. I just need the total to be 70.71 instead of 70.71 for accounting purposes. Thanks!

You're welcome, glad to help.

When rounding, keep in mind that you want to round as late as possible to avoid rounding errors. [e.g. ROUND(x+y) will be more accurate than ROUND(x)+ROUND(y)]

Hi

if your cell is formatted to 2 digit use this formula to add (CSE formula) =SUM(ROUND(YourSumRangeHere,2))

otherwise SUM will add actual cell value

makes sense. thanks everyone.