Select the checkbox “solver add-in” and click “Ok.”
The “solver add-in” is not enabled by default in Excel. The solver returns the best possible solution for a problem keeping in mind the set of controls. Hence, the entire solution is focused on the goal of the problem. The solver returns a solution that meets the goal and, at the same time, does not go beyond these limitations.