return wrong result of the cell
 

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

return wrong result of the cell
 

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