Addition of 2 cells is not correct

M

MAX

Cell O30 is the sum of such cells ----- € 1183.825
Cell O53 is the sum of such cells ------ € 743.990
Cell O56 is the sum of O30 and O53 and the answer is coming € 1927.814
instead of € 1927.815
All the 3 cells are in currency and to 3 decimal places.
Why the answer is coming with a difference of .001

Thanks for your help.
 
D

David Biddulph

I guess that you mean that you have DISPLAYED the cells to 3 decimal places,
but that that the underlying numbers have more places? You can check by
temporarily reformatting with more places.
You may want =ROUND(O30,3)+ROUND(O53,3)
 
P

Pete_UK

Increase the number of decimal places displayed in cells O30 and O53,
and you will see why. The displayed value is an approximation of the
real underlying value. Use ROUND( ... ,3) in your formulae to avoid
these errors.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"IF" then questio 2
dragging formula is giving me undesired result in cell calls. 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Addition errors with Decimal Places 6
Would like to input 3 letters into a cell, each having a different numerical value 5
Need a proper guru! My head hurts ;( 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Auto Sum not working correctly 1

Top