DISCOVER
×

How to solve quartic equations using excel

Updated April 17, 2017

Quadratic equations are one of the main equations used in algebra. The basic quadratic equation is axe(squared) + bx + c = 0. The solution for the quadratic equation is the quadratic formula. When solving quadratic equations in Excel, it is important to remember that all solutions will have two answers, one is negative and one is positive. Solving a quadratic equation using Excel can be a much easier and quicker way to solve a somewhat challenging mathematic equation.

Open a new blank workbook in Microsoft Office Excel.

Type "A," "B" and "C" in cells A1, B1 and C1. These will serve as the a, b and c in the quadratic equation.

Type in the values you are given for a, b and c in the quadratic equation in cells A2, B2 and C2 accordingly.

Skip a row in the workbook. Type x+= in cell in B4 and x-= in cell B5.

Type the following into cell C4 and press "Enter" to get the answer:

\=(-B2+SQRT(B2^(2)-4_A2_C2))/(28A2)

Type the following into cell C5 and press "Enter" to get the answer:

\=(-B2-SQRT(B2^(2)-4_A2_C2))/(28A2)

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Amy Ess has been writing both academically and professionally since 2002. She has served as the head grant writer for a nonprofit organization and received her Bachelor of Science degree in sociology from the University of Central Florida. Ess is currently studying for her master's degree in nonprofit management—also from The University of Central Florida.