You need to recheck what you did with your calculator, as you got it wrong.
Q36 is 3.344, not 3.344
Please check your own working before you suggest that Excel has got things
wrong.
--
David Biddulph

"Alan" wrote in message
...
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