Set Target Cell Specifies the target cell that you want to set to a certain value or that you want to maximize or minimize. This cell must contain a formula.

Equal To Specifies whether you want the target cell to be maximized, minimized, or set to a specific value. If you want a specific value, type it in the box.

By Changing Cells

Set Target Cell Specifies the cells that can be adjusted until the constraints in the problem are satisfied and the cell in the Set Target Cell box reaches its target. The adjustable cells must be related directly or indirectly to the target cell.

Guess Guesses all nonformula cells referred to by the formula in the Set Target Cell box, and places their references in the By Changing Cells box.

Subject to the Constraints

Subject to the Constraints Lists the current restrictions on the problem.Add Displays the Add Constraint dialog box. Change Displays the Change Constraint dialog box. Delete Removes the selected constraint.

Solve Starts the solution process for the defined problem.

Close Closes the dialog box without solving the problem. Retains any changes that you made by using the Options, Add, Change, or Delete buttons.

Options Displays the Solver Options dialog box, where you can load and save problem models and control advanced features of the solution process.

Reset All Clears the current problem settings, and resets all settings to their original values.