How to solve quartic equations using excel

Written by amy ess
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to solve quartic equations using excel
Quadratic equations can be solved using Microsoft Office Excel. (Jupiterimages, Brand X Pictures/Brand X Pictures/Getty Images)

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

Other People Are Reading

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

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

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.