Microsoft Office Tutorials and References
In Depth Information
Specifying variable cells
clicking OK (or by clicking Cancel). You also have the option of assigning the solution values
to a named scenario.
Figure 18-26 When the Solver succeeds, it presents the Solver Results dialog box.
Specifying integer constraints
Notice that in Figure 18-26, the Solver arrived at 53.3 for the number of ads placed in Pub4.
Unfortunately, because it’s not possible to run three-tenths of an advertisement, the
solution isn’t practical.
To stipulate that your ad-placement variables be restricted to whole numbers, start the
Solver and click the Add button in the Solver Parameters dialog box. In the Add Constraint
dialog box, select the cell reference that holds your ad placement numbers—D2:D7. Click
the list in the middle of the dialog box, and select int . The Solver inserts the word integer in
the Constraint box, as shown in Figure 18-27. Click OK to return to the Solver Parameters
Figure 18-27 To specify an integer constraint, select the item labeled int.