Excel formula is calculating wrong total number on some of cells
On Tue, 10 Mar 2009 01:04:01 -0700, Alan
wrote:
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
Your calculator is rounding the step where you compute O36 * 110%. The correct
answer to that is 3.344, but your calculator is dropping the last .004.
If you want the "correct" answer, you will have to figure out why your
calculator does not use more than two decimal digits.
If you want Excel to agree with your calculator, you will have to either
truncate or round your Q36 formula in the same way as your calculator is
altering the results.
--ron
|