# How do you get answer reports from solver?

Asked By: Angie Babaevsky | Last Updated: 3rd March, 2020

Category:
technology and computing
graphics software

The message "

**Solver**found a solution" appears in the**Solver**Results dialog, as shown above. (Click on the image to see it full size). We now click on "**Answer**" in the**Reports**list box to produce an**Answer Report**, and click OK to keep the optimal solution values in cells B4:E4.In this regard, how many different types of reports can Solver create?

You **can create** three **types of reports** using **Solver**. Each provides information on how the solution was reached. Each **report** is **created** on a separate worksheet.

Additionally, how do you activate solver? **Load the Solver Add-in in Excel**

- In Excel 2010 and later, go to File > Options.
- Click Add-Ins, and then in the Manage box, select Excel Add-ins.
- Click Go.
- In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
- After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.

Likewise, how do I use the Solver tool in Excel?

**Define and solve a problem**

- On the Data tab, in the Analysis group, click Solver.
- In the Set Objective box, enter a cell reference or name for the objective cell.
- Do one of the following:
- In the Subject to the Constraints box, enter any constraints that you want to apply by doing the following:
- Click Solve and do one of the following:

Where is Solver Parameters in Excel?

To let the **Excel Solver** know which cells on the worksheet represent the decision variables, constraints and objective **function**, we click **Solver** button on the **Excel** Data tab, or the Premium **Solver** button on the Add-Ins tab, which displays the **Solver Parameters** dialog.