ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel Solver (https://www.excelbanter.com/excel-worksheet-functions/50982-excel-solver.html)

Zeelotes

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.



Zeelotes

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