Excel Solver

Z

Zeelotes

I'm doing some extensive solving to find both the min and max values for a
particular formula based on a whole table of data. The solver finds the
optimal combination. Unfortunately, I'm finding that often the solver stops
almost immediately without actually changing anything. It accepts the max
value when I've actually asked for the min value. Is this a bug in the
solver or am I doing something incorrectly?

Any help would be appreciated.
 
Z

Zeelotes

Found the problem. Once Solver has completed a test and the solution is
found, the previous results have to be set back to the original values
before starting a new scenario.
 

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

Top