simple math formula
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
"Gabriel" wrote:
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
|