Addition of 2 cells is not correct
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.
|