Question: If using VBA to set parameters in the Solver box, which of the following would create the constraint to ensure that the value in cell
If using VBA to set parameters in the Solver box, which of the following would create the constraint to ensure that the value in cell G12 is 100?
A.
SolverAdd CellRef:=Range("G12"), Relation:">=", FormulaText:=100
B.
SolverAdd CellRef:=Range("G12"), ">=", FormulaText:=100
C.
SolverAdd CellRef:=Range("G12"), ">=", Value:=100
D.
SolverAdd "G12>=100"
E.
SolverAdd CellRef:=Range("G12"), Relation:=3, FormulaText:=100
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
