how to activate solver in excel mac 2011

Note that this cell must contain a formula.

Objective cell: The target cell in your worksheet whose value is to be maximized, minimized, or made to reach a particular value.

When setting up the problem for the Solver add-in in your Excel worksheet, define the following items:

To be sure that you are finding the best solution, you may want to run the Solver more than once, adjusting the initial values each time you solve the problem. Although the Solver returns the optimum solution, given the starting values, the variables that can change, and the constraints that you define, this solution is often not the only one possible and, in fact, may not be the best solution for you. When using the Solver add-in, keep in mind that many problems, especially the more complicated ones, have many solutions. With each iteration, the program applies a trial-and-error method (based on the use of linear or nonlinear equations and inequalities) that attempts to get closer to the optimum solution. The Solver add-in works by applying iterative methods to find the “best” solution given the inputs, desired solution, and the constraints that you impose. After opening Excel, the user must go to the add-in area. Solver for Excel 2011 for Mac downloads and installs directly onto the Excel program without any problems or user input required.When you're ready to use Solver, click the Solver button on the Data tab (the bundled version of Solver doesn't use the menu Tools Solver.). To use Solver, start Excel 2011 and create or open your workbook.

Within the Addin box, check ‘Solver.xlam’ then hit ‘OK’.

To enable Solver, click ‘Tools’ then ‘Addins’.

For example, use the Solver to find the best solution when you need to change multiple input values in your Excel model and you need to impose constraints on these values and/or the output value. And I can put ranges in the 'changing variable cells', as you can see in the following image: The version I tested is Excel for Mac version 16.37, may I confirm which Excel version you are using?Īlthough Excel’s Data Table and Goal Seek commands work just fine for simple problems that require determining the direct relationship between the inputs and results in a formula, you need to use the Solver add-in when dealing with more complex problems. But it turn out the solver add-ins is working perfectly on my side.

How to activate solver in excel mac 2011