View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 390
Default 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.