View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Addition of 2 cells is not correct

Hi,

Look here to find out why

http://www.mcgimpsey.com/excel/pennyoff.html

Mike

"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.