"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