View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.