excel result return wrong calcuation result
 

The cell K2 = sum( I2*AS2)
in which
I2= 20871 where the forumla here is I2=SUM(G2+H2)
AS2 =0.077 - where the forumla here is
=IF(ISERROR((AG2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AF2), "",((AG2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AF2))
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
mY EMAIL:

excel result return wrong calcuation result
 

why sum(I2*AS2)? why not just I2*AS2
sum(H2+G2) should be =h2+g2 or sum(H2,G2)
your 0.77 is actually 0.076593743 thats why you get 1598.588


--
paul

remove nospam for email addy!



"garyww" wrote:


The cell K2 = sum( I2*AS2)
in which
I2= 20871 where the forumla here is I2=SUM(G2+H2)
AS2 =0.077 - where the forumla here is
=IF(ISERROR((AG2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AF2),
"",((AG2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AF2))
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
mY EMAIL:


+-------------------------------------------------------------------+
|Filename: wrapwrepusage.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=74|
+-------------------------------------------------------------------+



--
garyww