Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with a simple formula | Excel Worksheet Functions | |||
math formula with upper and lower limits on data but also ranges | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |