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.

--
Hope this helps,
MarkN


"garyww" wrote:


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 |
+-------------------------------------------------------------------+

--
garyww
------------------------------------------------------------------------
garyww's Profile: http://www.excelforum.com/member.php...o&userid=35818
View this thread: http://www.excelforum.com/showthread...hreadid=571251