simple math formula

G

Gabriel

Hi!

Can somebody help me out with this formula?

=((1-E57)/1)*29000000; E57 is 76,96% and the outcome should be 6681600
while I get 6683009

Thanx
 
R

Ron Coderre

When I used your posted values, I received the correct return value of
6,681,600

However, when I used Goal Seek to back into the E57 value that generates
6,683,009, it returned this:
76.9551413793103%

Check to see if cell E57 displays 76.96% but is actually the above value.
If cell E57 contains a formula:
Select E57
Press [F2] to edit
Press [F9] to view it's calculated value

Is it 76.96% or 76.9551413793103%

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
T

tim m

I got the correct number when I tried it however, excel indicated I had an
error in the formula as listed by you and it moved a bracket thus the formula
I ended up with that worked was =((1-E57/1)*29000000)
 
I

Ian

Works here OK. I suspect it's a rounding error. Is E57 EXACTLY 76.96%. If
it's derived from a calculation it way be slightly different.
E57=0.7695514139 (76.95514139) gives a result of 6683009.
 
Top