Microsoft Office Tutorials and References
In Depth Information
EXTENDING THE EXAMPLE
When you click Change, the Change Constraint dialog box appears. Click the Cell Reference button;
the selected cells will appear on the spreadsheet with a moving marquee around them (see Figure D-34).
Highlight the new group of cells; when the new range appears in the Cell Reference field, click OK. The
Solver Parameters window appears with the constraint changed.
Adding cells H21 and H22 to the Trucks constraint cell range
You also need to update or add the following constraints:
Update $J$16:$J$20 >
0 to $J$16:$J$22 >
integer to $H$16:$H$22
integer. When changing integer constraints,
you must click
in the middle field of the Change Constraint dialog box; otherwise, you will
receive an error message.
integer to $J$16:$J$22
Add constraint $L$21 >
$G$21 (see Figure D-35).
Add constraint $L$22 >
Adding a constraint using the Add Constraint dialog box