In the dialog box:
Set Objective field allows to enter the cell address for the objective function value. The address in the screenshot is dollar sign D solar sign 5.
To field has three radio buttons labeled “Max,” “Min,” and “Value of” out of which the Max button is selected. This field helps to specify max or min.
By Changing Variable Cells field allows to enter the location of the values for the variables. The location in the screenshot is dollar sign B dollar sign 4 colon dollar sign C dollar sign 4.
A box titled “Subject to the constraints colon” is seen underneath with buttons to add, change, delete, reset all, and load/save.
A checkbox “Make unconstrained variables non-negative” is seen under the box and is ticket. This ...