Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Solver
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. |
#2
|
|||
|
|||
Excel Solver
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 4.0 macro removal tool | Excel Discussion (Misc queries) | |||
excel 4.0 macro remover tool | Excel Discussion (Misc queries) | |||
Excel solver sensitivity report has empty shadow prices column? | Excel Discussion (Misc queries) | |||
Excel Solver background in forecasting modeling | Excel Worksheet Functions | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |