simple math formula
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 |
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 |
simple math formula
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) "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 |
simple math formula
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. -- Ian -- "Gabriel" wrote in message ... 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 |
All times are GMT +1. The time now is 05:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com