cells adding problem

[Bentley]

When I add two numbers from two cells (=b9 + c9) the answer in d9 is one cent
too much. If I add the exact numbers instead of the cell reference, then the
result is correct (b9= 47,334.89; c9= -33,113.61 and correct answer is
14,221.28). What is adding the extra penny to give me 14,221.29?

 

[Niek Otten]

http://www.mcgimpsey.com/excel/pennyoff.html

 

[Ragdyer]

I'll bet that there are formulas in B9 and C9, and you have those cells
*formatted* to 2 decimal places!

Don't forget, formatting only changes the display of the value, *not* the
actual value, so I would guess that the *actual* values in those 2 cells are
not exactly what's displayed.

You may want to *round* your formulas, so that WYSIWYG.

=ROUND("your formula",2)

 

[Bernard Liengme]

Select each of B9 and C9 in turn and look in Formula bar.
Are they formulas or values?
I expect these cells are formatted to display 2 decimal values but actually
hold values with more
Example 2.334 and 3.334 would add to 5.67 but you are seeing 2.33 + 3.33 =
5.67

Solution? Depends on your needs.
If B9 and C9 have formulas change the to ROUND(formula,2)
OR in D9 use =ROUND(B9,2)+ROUND(C9,2)

Happy New Year