Microsoft Office Tutorials and References
In Depth Information
Finding optimal solutions by using Solver
7
Click in the By Changing Variable Cells field, and select cells E5:E8 . $E$5:$E$8
appears in the By Changing Variable Cells field.
8
Click Add to open the Add Constraint dialog box.
9
Select cells E5:E8 . $E$5:$E$8 appears in the Cell Reference field.
10
In the operator list, click int . Then click Add . Excel adds the constraint to the Solver
problem, and the Add Constraint dialog box clears to accept the next constraint.
11
Click cell F9 . $F$9 appears in the Cell Reference field. Verify that the operator <=
appears in the operator field.
12
Click in the Constraint field, and then click cell G11 . =$G$11 appears in the
Constraint field.
13
Click Add . Excel adds the constraint to the Solver problem, and the Add Constraint
dialog box clears to accept the next constraint.
8
14
Click cell G9 . $G$9 appears in the Cell Reference field.
15
In the operator list, click >= .
16
Click in the Constraint field, and then click cell G12 . =$G$12 appears in the
Constraint field.
17
Click Add . Excel adds the constraint to the Solver problem, and the Add Constraint
dialog box clears to accept the next constraint.
 
Search JabSto ::




Custom Search