Solutions of Nonlinear Programming Models with Microsoft Excel Will Often

Multiple Choice

Solutions of nonlinear programming models with Microsoft Excel will often generate "division by zero" errors. To avoid these errors, the decision maker should:

A) Ignore them and read the solution as provided by Excel.
B) Accept the errors as part of the solution (i.e., there is no solution to the given problem) .
C) Add a non-negativity constraint for decision variables instead of checking the non-negativity box in Solver.
D) All of the above