# How to Use a Root Solver in Excel

Save

Microsoft Excel's solver tool changes the value in one cell to supply a desired result in another on whose contents the first depends. The tool has various practical applications, such as producing sales figures necessary to achieve a target profit. But it also has a pure mathematical application in finding the root, or solution of an equation. This is especially useful for higher order equations that are very difficult to solve manually.

• Click "File" from Excel's menu bar.

• Click "Options." The "Excel Options" window will open.

• Click "Add-Ins" in the left pane. Click "Solver Add-in" from the right pane.

• Click the "Go" button. The "Add-Ins" dialog box will open.

• Check the box next to "Solver Add-in." Click "OK."

• Type your equation into a cell, using a second cell as a reference. For instance, if your equation is "4x^3 + 2x^2 - 87 = -1," type into cell A1, "=4 A2^3 + 2 A2^2 - 87."

• Click on the "Data" ribbon.

• ### Other People Are Reading

• Click "Solver" from the "Analysis" tab. The "Solver Parameters" window will open.

• Enter the reference of the cell into which you typed the formula in the "Set Objective:" box. In this example, type "A1."

• Click the "Value of:" button.

• Enter your target value in the "Value Of:" box. In this example, type "-1."

• Type the formula's reference cell in the "By Changing Variable Cells:" box. In this example, type "A2."

• Click "Solve." Excel will change both cells accordingly. In this example, cell A1 will change to "-1.00007," which is very close to "-1." Cell A2 will change to "2.623573," which is a root of the equation.

## References

• Photo Credit Jupiterimages/Photos.com/Getty Images
Promoted By Zergnet

## Related Searches

Check It Out

### Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.