return wrong result of the cell

[garyww]

dear exceltips,

The cell K2 = sum( I2*AS2)
in which
i2= 20871
AS2 =0.077.
So, the correct result should be K2= 1607.067.
Why it calculates to the cell of K2 result return now is
1598.588 - it is wrong answer.

For details, pls see the wrapwrepusage.zip file


It is a big different.
Pls instruct !
thanks
gary


+-------------------------------------------------------------------+
|Filename: wrapwrepusage.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5186 |
+-------------------------------------------------------------------+

 

[Guest]

If you look at AS2, the actual value of the cell is 0.07659375, but it is
formatted to appear as 0.077. Use the round function on the formula in AS2

=ROUND(IF(ISERROR((AG2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AF2),
"",((AG2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AF2)),3)

and things should work nicely.