Page 679 - Excel 2013 All-in-One For Dummies

Excel opens the Solver Parameters dialog box, which is similar to the one shown in Figure 1-12.
2. Click the target cell in the worksheet or enter its cell reference or range name in the Set Objective text box.
Next, you need to select the To setting. Click the Max option button when you want the target cell’s value to be as large as possible. Click the Min option button when you want the target cell’s value to be as small as possible. Click the Value Of option button and then enter a value in the associated text box when you want the target cell’s value to reach a particular value.
3. Click the appropriate option button option in the To section of the dialog box. If you select the Value Of option button, enter the value to match in the associated text box.
Next, designate the variable cells — that is, the ones Solver can change to reach your Equal To goal.
4. Click the By Changing Variable Cells text box and then select the cells to change in the worksheet or enter their cell references or range name in the text box.
Remember that to select nonadjacent cells in the worksheet, you need to hold down the Ctrl key as you click each cell in the selection. 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.
Using the Solver 661
Figure 1-12:
Specifying the parameters to apply to the model in the Solver Parameters dialog box.
Book VII Chapter 1
Performing What-If Scenarios