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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 + Solver 3
"DoEvents"-type behavior in Solver? 1
Using Solver in VBA 1
Can I use solver to estimate several values by changing several c. 1
Automate a Solver solution 10
Changing cells in solver. 1
Solving multiple equations 5
Solver Function - Making it Automatic 6

Back
Top