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.

  • 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

Comments

Resources

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.
Submit Your Work!