Microsoft Office Tutorials and References
In Depth Information
Finding optimal solutions by using Solver
After the installation is complete, Solver appears on the Data tab, in the Analysis group.
Clicking Solver displays the Solver Parameters dialog box.
The first step of setting up your Solver problem is to identify the cell that contains the
summary formula you want to establish as your objective. To identify that cell, click in the Set
Objective box, click the target cell in the worksheet, and then select the option that
represents whether you want to minimize the cell’s value, maximize the cell’s value, or make the
cell take on a specific value. Next, you click in the By Changing Variable Cells box and select
the cells Solver should vary to change the value in the objective cell.