Microsoft Office Tutorials and References
In Depth Information
=$G$13 appears in the Constraint field.
19. Click Add .
Excel adds the constraint to the Solver problem, and the Add Constraint dialog box
clears to accept the next constraint.
20. Click cell E8 .
$E$8 appears in the Cell Reference field.
21. In the operator list, click >= .
22. Click in the Constraint field, and then click cell G14 .
=$G$14 appears in the Constraint field.
23. Click Add .
Excel adds the constraint to the Solver problem, and the Add Constraint dialog box
clears to accept the next constraint.
24. Select cells E5:E8 .
$E$5:$E$8 appears in the Cell Reference field.
25. 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.
26. 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.
27. Click Solve .
The Solver Results dialog box opens, indicating that Solver found a solution. The
result is displayed in the body of the worksheet.
Search JabSto ::




Custom Search