Standard Excel Solver - Messages in the Solver Results Dialog (0)

Messages in the Solver Results Dialog (0)

Solver found a solution. All constraints and optimality conditions are satisfied. (0)

This means that the Solver has found the optimal or "best" solution under the circumstances. The exact meaning depends on whether you are solving a linear, nonlinear, or integer programming problem.

If you are solving a linear programming problem (Assume Linear Model in the Solver Options dialog is checked) with no integer constraints, the Simplex Solver has found the globally optimal solution: There is no other solution satisfying the constraints which has a better value for the objective (Target Cell). It is possible that there are other solutions with the same objective value, but all such solutions are linear combinations of the current decision variable values.

If you are solving a nonlinear programming problem (Assume Linear Model is not checked) with no integer constraints, the GRG Solver has found a locally optimal solution: There is no other set of values for the decision variables close to the current values and satisfying the constraints which yields a better value for the objective (Target Cell). In general, there may be other sets of values for the variables, far away from the current values, which yield better values for the objective.

If you are solving a mixed-integer programming problem (any problem with integer constraints) with the default Tolerance value (in the Solver Options dialog) of 0.05, the Branch and Bound algorithm has found a solution satisfying the constraints (including the integer constraints) whose objective value is within at least 5% of the true optimal objective value.

If you have set the Tolerance to zero and you've checked the Assume Linear Model box, the true integer optimal value has been found. If the Tolerance is zero and the Assume Linear Model box is not checked, the Branch and Bound algorithm has found the best of the locally optimal solutions found for subproblems by the GRG Solver engine.

Next Solver Results Message >

< Back to Standard Excel Solver:  Help with Specific Solver Messages

< Back to Standard Excel Solver Support Information

To Learn More: For instant access to our white papers, example models, full-text User Guides, and to download free 15-day trial versions of our software products whenever you're ready, register now with no obligation.

User type Please Select Commercial User Consultant Corp Developer Govt/Military Professor Student VAR/ISV Firm Email address Name First Last Company University Phone

Trial version passwords are sent to the above email address. Our Privacy Policy protects you.