# How to solve quartic equations using excel

Written by amy ess
• Share
• Tweet
• Share
• Pin
• Email

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.

Skill level:
Moderately Easy

## Instructions

1. 1

Open a new blank workbook in Microsoft Office Excel.

2. 2

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

3. 3

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

4. 4

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

5. 5

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

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

6. 6

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

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

### Don't Miss

#### References

• All types
• Articles
• Slideshows
• Videos
##### Sort:
• Most relevant
• Most popular
• Most recent