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. |
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. |
All times are GMT +1. The time now is 06:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com