Can solver be used to make a cell equal to another cell

B

BF

In Excel 97 I need solver to solve for a y= equation. However y changes
depending on values in other cells. How can make solver automatically change
it's answer as what it is solving for changes?
 
V

Vic Sowers

BF said:
In Excel 97 I need solver to solve for a y= equation. However y changes
depending on values in other cells. How can make solver automatically
change
it's answer as what it is solving for changes?
Click to expand...

try equation-y = 0
 
T

Tushar Mehta

Solver by itself doesn't run itself when the worksheet changes. You
have to initiate Solver by hand. Also, it is not a good idea...no
scratch that...it is a very bad idea...to run an optimization (which is
what Solver does) through an event procedure such as Worksheet_Change.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 
Top