Question

Use Solver in Excel - this is how it works

Answer 1

This is the Excel solver
Excel: Add Solver
1st step:
2nd step:
3rd step:
4th step:
5th step:
Use Solver in Excel
1st step:
2nd step:
3rd step:
4th step:
5th step:
6th step:
Quick guide: Adding a solver in Excel
Brief instructions: Using the Excel solver

---

Would you like to know what the Excel add-in Solver is and how you can use it? We'll show you..

You can use add-ins to take advantage of advanced functions in Excel. One such add-in is the solver. With its help you can display the value in one cell in relation to values ​​in other cells. This article tells you what exactly the solver is and how to use it.

• This is the Excel solver
• Excel: Add Solver
• Use Solver in Excel

This is the Excel solver

With the "Solver" add-in you can perform a what-if analysis in Excel. You mark a target cell, the value of which depends on the values ​​of other table cells. With the solver you can display the result for the target cell with different starting values. For example, you could find out how investing more or less money in customer service would affect your sales.

Excel: Add Solver

To add the Solver add-in, follow our step-by-step instructions or take a look at the quick start guide ..

1st step:

Click on the " File " tab at the top.

2nd step:

Then go to the " Options " on the left (possibly hidden under "More"). A new window will open.

3rd step:

Left click on " Add-Ins " and then below in the " Manage " to " Excel Add-ins ". Then click on " Go ... ". A new window will open.

4th step:

Now put on " Add-Ins available " the Häkche n at " solver " and then click " OK ".

5th step:

As soon as the add-in is loaded, the " Solver " function is displayed under the " Data " tab in the " Analysis " group .

Use Solver in Excel

Follow our step-by-step instructions or take a look at the brief instructions .

1st step:

Open the solver window by clicking on " Solver " in the " Data " tab under " Analysis " .

2nd step:

At the top of the window you can now specify your target cell . It is important that there is a formula in this cell .

3rd step:

Directly below ("To") you can now specify what kind of value should be determined for the target cell. It can be the maximum, the minimum or a certain value.

4th step:

With " By changing variable cells" you can select the cells whose contents are variable and which affect the target cell.

5th step:

With " Subject to secondary conditions " you can now define secondary conditions. For example, that the value in the target cell must not exceed a certain value. To do this, click on " Add " and then define the secondary condition.

6th step:

Now choose a solution method and finally click on " Solve ". The solution that the solver has calculated is now displayed in the target cell. You can use the result directly, discard it or save it as a scenario.

Quick guide: Adding a solver in Excel

1. Go to the " File " tab and then to " Options " on the left (if necessary under "More").
2. In the new window select " Add-Ins " on the left and then under " Manage " the " Excel Add-Ins ". Confirm with " Go ... ". A small window will open.
3. For " Available Add-Ins " check the box for " Solver " and confirm with " OK ".
4. Once the add-in has been loaded, the " Solver " function is available under the " Data " tab in the " Analysis " group .

Brief instructions: Using the Excel solver

1. Open the solver by clicking on " Solver " under " Data " under " Analysis " .
2. At the top of the window, set your target cell . This must contain a formula.
3. With " To " you set which value is determined for the target cell (maximum, minimum, specific value).
4. You can now select cells whose variable content affects the target cell (" By changing variable cells "). You can also add constraints (" Subject to constraints ")
5. Finally, choose a solution method and then click " Solve ". The result is displayed to you

---