Solve Objective Function

The objective function states the quantity that you want Solve to optimize.

  1. Choose whether the objective is to

    • Maximize

    • Minimize

    • Set the value of

    the value in selected cells.

  2. Select the cells whose values can be changed to achieve the objective. To have an effect, the variable cells must be related to the objective cells in some way, or to the cell reference in at least one constraint.

  3. Select the Make Unconstrained Variables Non Negative option to specify that all decision variable cells without explicit minimum values should be given minimum values of zero. If you define a constraint that specifies a minimum value different from zero, that constraint will override this option for the cells it relates to.