View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.