Microsoft Office Tutorials and References
In Depth Information
USING EXCEL SOLVER
You are ready to enter the constraints as equations or inequalities in the Add Constraint dialog box. To
begin, click the Add button in the Solver Parameters window. In the dialog box that appears (see Figure D-19),
click the button at the right edge of the Cell Reference box, select cells H16 to H20, and then click the button
again. Next, click the drop-down menu in the middle field and select >
. Then go to the Constraint field and
type 0. Finally, click Add; otherwise, the constraint you defined will not be added to the list defined in the Solver
Parameters window.
¼
FIGURE D-19
Add Constraint dialog box
You can continue to add constraints in the Add Constraint dialog box. For this example, enter the
constraints shown in the completed Solver Parameters window in Figure D-20. When you finish, click Add to
save the last constraint, then click Cancel in the Add Constraint dialog box to return to the Solver Parameters
window.
FIGURE D-20
Completed Solver Parameters window
If you have difficulty reading the constraints listed in Figure D-20, use the following list instead:
￿
$H$16:$H$20
integer
¼
￿
$H$16:$H$20 >
0
¼
￿
$H21 <
$F$5
¼
 
Search JabSto ::




Custom Search