In this tutorial, you will learn how to solve a quadratic equation in Excel.

An algebraic equation of the second degree in x is a quadratic equation. The quadratic equation is written as ax2 + bx + c = 0, where x is the variable, a and b are the coefficients, and c is the constant term. The requirement that the coefficient of x2 be a non-zero term (a 0) is necessary for an equation to qualify as a quadratic equation. The x2 term is written first when constructing a quadratic equation in standard form, then the x term, and finally the constant term.

Once ready, we’ll get started by utilizing real-world examples to show you how to solve a quadratic equation in Excel.

Table of Contents

## Solve a Quadratic Equation in Excel

Before we begin we will need a group of data to solve a quadratic equation in Excel.

As an illustration, consider the formula y = 3×2 – 12x + 9.5. It is simple to determine y for any given x. For x = 1, y = 0.5

What if, however, we wish to learn x for every given y? Y = 24.5, as an illustration. Solving 3×2 – 12x + 9.5 = 24.5 is necessary. Using the quadratic formula, we can find the solution to the quadratic equation 3×2 – 12x + 9.5 – 24.5 = 0.

### Step 1

We can first select â€˜What-If Analysisâ€™ then select â€˜Goal Seekâ€™.

### Step 2

In the pop-up box, we will then select Y value as â€˜Set cellâ€™, and X value as â€˜By changing cellâ€™.

### Step 3

Once we are done, you will be able to solve a quadratic equation in Excel.