G
Guest
Hi
I am trying to solve for a variable that refers to itself. I am using MS
Excel 2003. I have a feeling I need to use the iteration function or solve
mathematically but am wondering if I can get some hints.
Example: solving for "A." All of the other numbers are variables that I
can solve for separately, and are used as examples here.
A = (2,403,293*54.23)/(129,788,655+(2,405,539*(A-0.07)/A))
If I do something like B44=(B38*B39)/(B40+(B20*(B44-B25)/B44)) I'll get the
#DIV/0! error.
Same if I try to split out the formula into 2 formulas and making them
dependent on one another:
B41=(B20*(B42-B25))/B42
B42=(B38*B39)/(B40+B41)
Any hints to help me would be greatly appreciated!
Thank you for your time and wisdom.
MikeyT
I am trying to solve for a variable that refers to itself. I am using MS
Excel 2003. I have a feeling I need to use the iteration function or solve
mathematically but am wondering if I can get some hints.
Example: solving for "A." All of the other numbers are variables that I
can solve for separately, and are used as examples here.
A = (2,403,293*54.23)/(129,788,655+(2,405,539*(A-0.07)/A))
If I do something like B44=(B38*B39)/(B40+(B20*(B44-B25)/B44)) I'll get the
#DIV/0! error.
Same if I try to split out the formula into 2 formulas and making them
dependent on one another:
B41=(B20*(B42-B25))/B42
B42=(B38*B39)/(B40+B41)
Any hints to help me would be greatly appreciated!
Thank you for your time and wisdom.
MikeyT