Excel Solver

[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.

 

[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.