On Mar 10, 12:04*am, Alan wrote:
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).

The Excel result in R36 is correct (approximately) for the procedure
that you describe.

I suspect you are fooling yourself because some cells (notably Q36 and
R36) are formatted with 2 decimal places.

As you describe it, Q36 is actually about 3.344. That might
__display__ as 3.34 due to cell formatting. But the __actual__
underlying value is still about 3.344.

Consequently, the formula in R36 is effectively 3.344*1434, not
3.34*1434. The extra 0.004*1434 is sufficient to explain the
difference that you see.

Moreover, it should be noted that R36 is really about 4795.296, not
4795.30 -- again, because of the difference between the displayed
value due to cell format and actual underlying value. This might
propagate "error" (misunderstanding) throughout your worksheet.

At a minimum, apparently you want the formula in Q36 to be =ROUND
(O36*110%,2). It would be prudent to also change the formula in R36
to =ROUND(L36*Q36,2).