Solving a formula

[Guest]

Is there a function I can use to solve a formula so that one cell equals
another cell by changing another cell. I have found the solver function which
allows me to change a cell so another one equals a fixed number which has to
be typed in, however I have hundreadsd of lines and don't want to have to
type in the number to solve for but just refer to a cell.

 

[Guest]

The company that makes the solver tool for Excel has a more robust version of
their software, at www.solver.com, which may do what you're looking to do.

Dave

 

[James Silverton]

Hello, Ben!
You wrote on Fri, 20 Oct 2006 08:50:02 -0700:

B> Is there a function I can use to solve a formula so that one
B> cell equals another cell by changing another cell. I have
B> found the solver function which allows me to change a cell
B> so another one equals a fixed number which has to be typed
B> in, however I have hundreadsd of lines and don't want to
B> have to type in the number to solve for but just refer to a
B> cell.

Basically, I think the Excel process is "Goal Seek", which does
just that. Check HELP but I don't know how to use it for several
cells automatically. Perhaps it could be handled by VBA.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

 

[vezerid]

Ben,

Instead of typing the number in each instance of Solver you can have it
in a separate cell. Then use a third cell =TargetCell-Value. Use the
third cell as target cell in solver and always ask it to be 0.

Does this help?
Kostis Vezerides