Asked by knmk

What is the maximum number of cells a user can select for the Set Objective variable in the Solver Parameters dialog box?

A user can select only a single cell for the Set Objective variable.
A user can select up to three cells for the Set Objective variable.
A user can select any number of cells for the Set Objective variable.
A user can select as many active cells as a worksheet contains for the Set Objective variable.

All Answers 1

Answered by GPT-5 mini AI
A user can select only a single cell for the Set Objective variable. Standard Excel Solver accepts one objective cell (minimize, maximize, or set to a value).