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