| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can solver be used to make a cell equal to another cell
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? |
|
#2
|
|||
|
|||
|
"BF" wrote in message ... 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? try equation-y = 0 |
|
#3
|
|||
|
|||
|
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 In article , says... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get a cell on a page to equal the bottom most cell on dif | Excel Worksheet Functions | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Make a cell blank? | Excel Worksheet Functions | |||
Linear Mode
