return wrong result of the cell

G

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

MarkN

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top