Microsoft Office Tutorials and References
In Depth Information
Finding optimal solutions by using Solver
18
Select cells E5:E7 . $E$5:$E$7 appears in the Cell Reference field.
19
In the operator list, click >= .
20
Click in the Constraint field, and then click cell G13 . =$G$13 appears in the
Constraint field.
21
Click Add . Excel adds the constraint to the Solver problem, and the Add Constraint
dialog box clears to accept the next constraint.
22
Click cell E8 . $E$8 appears in the Cell Reference field.
23
In the operator list, click >= .
24
Click in the Constraint field, and then click cell G14 . =$G$14 appears in the
Constraint field.
25
Click Add . Excel adds the constraint to the Solver problem, and the Add Constraint
dialog box clears to accept the next constraint.
26
Select cells E5:E8 . $E$5:$E$8 appears in the Cell Reference field.
27
Verify that the <= operator appears in the operator field, click in the Constraint field,
and then click cell G15 . =$G$15 appears in the Constraint field.
28
Click OK . Excel adds the constraint to the Solver problem and closes the Add
Constraint dialog box, and the Solver Parameters dialog box opens again.
Search JabSto ::




Custom Search