Goal Seek - show formula?

[Guest]

Is there a way to show the formula that Goal Seek function uses to arrive at its answer
I have a simultaneous equation with variables and the only method that gives me
the answer I need is "goal seek". I have several rows that need the same cal
and I don't want to manually use goal seek over and over again. I would like t
just know the formula and then copy it down the page

Any ideas?

 

[Bernard V Liengme]

Hi Kelly,
Goal Seek does not use a formula, it uses an iterative algorithm.
Find a math book and read how Newton;s Method of Successive Approximations
works to get an idea.

You can solve simultaneous equations with the Excel matrix function MINVERSE
and MMUTI
Send me (private email not to newsgroup) a real email address and I will
send info

Bernard
www.stfx.ca/people/bliengme

 

[Guest]

Do I just take out the "TRUENORTH" in your address to e-mail to you at .ca ?

 

[Bernard V Liengme]

Yes. And please send second message I think I mistakenly delete one of
yours!
Bernard

Do I just take out the "TRUENORTH" in your address to e-mail to you at .ca

?