## Example

```
=(-C12+SQRT(C12^2-4*B12*D12))/(2*B12)
```

## Generic Formula

There are two possible solutions for any quadratic equation. This is one possible solution.

```
=(-B+SQRT(B^2-4*A*C))/(2*A)
```

This is the other possible solution.

```
=(-B-SQRT(B^2-4*A*C))/(2*A)
```

**A**– This is the coefficient of the squared term in the quadratic equation.**B**– This is the coefficient of the single powered term in the quadratic equation.**C**– This is the constant in the quadratic equation.

## What It Does

These formulas will give the solutions to a quadratic equation of the form Ax^2 + Bx + C = 0.

## How It Works

This is a simple algebraic formula and uses the SQRT function which returns the square root of a given number and the ^ operator which raises a given number to a given power.

In our example x^2 – 3x + 2 = 0 the solution is given by =(-(-3)+SQRT(-3^2-4*1*2))/(2*1) which results in **2**. Similarly the other solution is **1**.

Not every quadratic equation has a solution in the real numbers, when this is the case the formula will result in a #NUM! error.

## 0 Comments