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

Question

Quizplus · Accepted Answer

Adding a non-negativity constraint for decision variables directly in the model can help avoid "division by zero" errors by ensuring that variables do not take on values that would result in such errors, unlike simply checking a box in Solver which might not address the root cause of the problem.

Solutions of Nonlinear Programming Models with Microsoft Excel Will Often