Excel 2010 Bible

Chapter 37: Analyzing Data Using Goal Seeking and Solver

767

FIGURE 37.4

The Solver Parameters dialog box.

In this example, the target cell is D6 — the cell that calculates the total profit for three products.

1. Enter D6 in the Set Objective field of the Solver Parameters dialog box.


2. Because the objective is to maximize this cell, select the Max option button.


3. Specify the changing cells (which are in the range B3:B5) in the By Changing
   Variable Cells field. The next step is to specify the constraints on the problem. The con-
   straints are added one at a time and appear in the Subject to the Constraints list.


4. To add a constraint, click the Add button. Excel displays the Add Constraint dialog
   box, shown in Figure 37.5. This dialog box has three parts: a Cell Reference, an operator,
   and a Constraint value.

FIGURE 37.5

The Add Constraint dialog box.