67.3k views
2 votes
"A message in the Excel Solver Results dialog box telling you that the “Objective Cell values do not converge” is given when you attempt to solve a(n) _______________ problem."

User Edgarian
by
6.3k points

1 Answer

6 votes

Answer:

optimization modelling problems

Step-by-step explanation:

A message in the Excel solver result dialogue box saying " Objective cell values do not converge" means that the objectives function that we have provided does not give the best result or optimum result close to the solution.

In other words excel is finding it difficult to provider a solution anything close to the optimal value despite of many iterations because the constrain formula are not properly defined.

User Djordje Ivanovic
by
6.9k points