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.
