To save the changes as a scenario before you restore the original values, click the Save Scenario button and assign a name to the current scenario before you click the Restore Original Values option and OK button.

With each iteration, the program applies a trial-and-error method (based on the use of linear or nonlinear equations and inequalities) that attempts to get closer to the optimum solution.

Although the Solver returns the optimum solution, given the starting values, the variables that can change, and the constraints that you define, this solution is often not the only one possible and, in fact, may not be the best solution for you.

To be sure that you are finding the best solution, you may want to run the Solver more than once, adjusting the initial values each time you solve the problem.

At this point, you can choose to retain the changes in the worksheet or restore the original values to the worksheet.

You can also save the solution as a scenario to view later before you restore the original values.

The changing cells that you define for the Scenario Manager are automatically picked up and used by the Solver when you select this command, and vice versa.

Also, you can save the Solvers solution to a problem as a scenario (by clicking the Save Scenario button in the Solver dialog box) that you can then view with the Scenario Manager.

This means that, before you can use it, you need to make sure that the Solver add-in program is still loaded, as indicated by the appearance of the Solver button in the Analysis group at the end of the Data tab on the Ribbon.

If this button is missing, you can load Solver by opening the Add-Ins tab of the Excel Options dialog box (AltFTAA) and then clicking the Go button after making sure that Excel Add-Ins is displayed in the Manage drop-down list box to its immediate left.

Then, select the Solver Add-in check box in the Add-Ins dialog box to put a check mark in it before you click OK to close the dialog box and reload the add-in.

Click the Min option button when you want the target cells value to be as small as possible.

If you select the Value Of option button, enter the value to match in the associated text box.

To have Excel choose the changing cells for you based on the target cell that you selected, click the Guess button to the right of this text box.

When defining a constraint, choose the cell whose value you want to constrain or select the cell in the worksheet or enter its cell reference in the Cell Reference text box.

Then select the relationship (,, or int for integer or bin for binary) from the drop-down list box to the right and (unless you chose int or bin ) enter the appropriate value or cell reference in the Constraint text box.

After you finish defining constraints for the target cell and changing values in the model, click OK to close the Add Constraint dialog box and return to the Solver Parameters dialog box (which now lists your constraints in the Subject to the Constraints list box).

By default, the Solver Add-in employs the GRG (Generalized Reduced Gradient) Nonlinear method in solving the model whose parameters youre setting known as a very efficient way to solve smooth nonlinear problems.

To use the LP Simplex method (for Linear Programming following the Simplex algorithm) or Evolutionary engine for solving non-smooth problems, you need to follow Step 7.

To interrupt the solution process at any time before Excel calculates the last iteration, press the Esc key.

Excel then displays the Show Trial Solution dialog box, informing you that the solution process has been paused.

This dialog box informs you whether the Solver was able to find a solution, given the target cell, changing cells, and constraints defined for the problem.

To retain the changes that the Solver makes in your worksheet model, leave the Keep Solver Solution option button selected and click OK to close the Solver Results dialog box.

To return the original values to the worksheet, click the Restore Original Values option button instead.

Youtbe Excel Solver For Mac