View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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