In OptQuest, constraints limit the possible solutions to a model in terms of relationships among the decision variables. You can use the Constraints panel to specify linear and nonlinear constraints. For example, in Tutorial 2 — Portfolio Allocation Model , the total investment was limited to $100,000. In the Constraints panel, this limit is expressed by the formula:
Money Market fund + Income fund + Growth and Income fund + Aggressive Growth fund = 100000
By default, the Constraints panel opens in Simple Entry mode. In this mode, most of the constraint formula is entered into cells in your spreadsheet. You then complete the constraint formula on the Constraints panel using a simple conditional expression like Sheet!A1 <= 100.
For more information, see the following section, Specifying Constraints in Simple Entry Mode.
If you move to Advanced Entry mode, you can enter constraint formulas directly. See Specifying Constraints in Advanced Entry Mode.
Note: | You can create multiple constraints without using all of them at once. If you select Exclude, that constraint is not used in the current OptQuest optimization. You can now create bulk constraints by using cell ranges on either side of the constraint formula in both Simple Entry and Advanced Entry modes (Using Bulk Constraints). |