View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Alan is offline
external usenet poster
 
Posts: 152
Default Excel formula is calculating wrong total number on some of cells

Hi!

I having 1 problem that Excel formula is calculating wrong total number on
some of cells. For example:

1)M36=2.83
2)O36=ROUND(M36*1.075,2)
3)Q36=O36*110%
4)L36=1434
5)R36=L36*Q36
The R36 total is 4795.30 (wrong)

When I used calculator to calcalate it, the correct total is 4789.56
(Formula is 3.34*1434=4789.56).

May I know how to solve this problem? Please give advise. Thank you!

Regards,
Alan