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.

Hi,

Look here to find out why

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

Mike

"MAX" wrote:

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.

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

On Feb 18, 12:26*pm, MAX wrote:
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.

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)
--
David Biddulph

"MAX" wrote in message
...
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.