Microsoft Office Tutorials and References
In Depth Information
8. 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.
9. Click cell F9 .
=$F$9 appears in the Cell Reference field.
10. Click in the Constraint field, and then click cell G11 .
=$G$11 appears in the Constraint field.
11. Click Add .
Excel adds the constraint to the Solver problem, and the Add Constraint dialog box
clears to accept the next constraint.
12. Click cell G9 .
$G$9 appears in the Cell Reference field.
13. In the operator list, click >= .
14. Click in the Constraint field, and then click cell G12 .
=$G$12 appears in the Constraint field.
15. Click Add .
Excel adds the constraint to the Solver problem, and the Add Constraint dialog box
clears to accept the next constraint.
16. Select cells E5:E7 .
$E$5:$E$7 appears in the Cell Reference field.
17. In the operator list, click >= .
18. Click in the Constraint field, and then click cell G13 .
Search JabSto ::




Custom Search