Microsoft Office Tutorials and References
In Depth Information
Tip You might be prompted for the Microsoft Office system installation CD. If so, put the CD
in your CD drive, and click OK.
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
representing 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. Finally,
you can create constraints that will set the limits for the values Solver can use. To do so,
click Add to open the Add Constraint dialog box.