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