**Microsoft Excel** is mainly used for statistical analysis, keeping and tracking records, making and analyzing reports, etc. Apart from these, users can solve different equations like linear, **quadratic,** cubic, and others. The process for solving these equations in Excel is slightly different than how we generally do it. In this article, we will show you **how to solve cubic equation in Excel**.

## Download Practice Workbook

You can download the free **Excel** workbook here and practice on your own.

## 2 Ways to Solve Cubic Equation in Excel

To illustrate our article, first we need to take a cubic equation. The equation we want to solve in our procedure is **Y = X ^{3}+8X^{2}+19X+12**. In this article, we will use two different methods to solve this cubic equation in Excel. Firstly, we will utilize the

**feature of Excel to solve the equation, and secondly, we will utilize the**

*Goal Seek***add-in of Excel to get a result from this equation. In both procedures, we will assume a value of**

*Solver***and then, by using that value, we will**

*Y,***calculate a value of**

*X*.For our calculation process, we’ve arranged the equation on a worksheet like the following image. Here, we have shown the variables and the coefficient separately.

### 1. Utilizing Goal Seek Feature to Solve Cubic Equation in Excel

For our first procedure, we will utilize the** Goal Seek** feature of Excel. By using this feature, we will set the final result of an equation as an input, and this feature will change the variables depending on this outcome and show the variable as the result of this goal seeking. For detailed steps of this procedure, follow the below description.

**Step 1:**

- First of all, make a new table under the main data set to show the results after calculation.
- Then, we will set
as the initial value of*0*.*X*

**Step 2:**

- Secondly, use the following formula to determine the value of
when the initial value of*Y*is zero.*X*

`=B13^3*C5+B13^2*C6+B13*C7+C9`

**Step 3:**

- Thirdly, press
to get the value for*Enter*which is*Y*.*12*

**Step 4:**

- Then, after finishing all the calculations, go to the
group of the ribbon.*Forecast* - From there, choose the
*What-If*.*Analysis*

**Step 5:**

- Fifthly, from the dropdown menu, select
.*Goal Seek*

**Step 6:**

- In this step, we will
**find the value of***X*for a predetermined value of*Y*. - After choosing the command from the previous step, you will see the
dialog box.*Goal Seek* - Firstly, in the “
” type box, input the cell address that will be the final output of this goal.*Set cell* - Then, in the “
” type box, set the new output for the cell chosen in the previous step.*To value* - Thirdly, in the “
” type box, select the cell, by altering which we will get the above outcome.*By changing cell* - Lastly, press
.*OK*

**Step 7:**

- Finally, after pressing
, the*OK*feature will take some time and show the result after calculation.*Goal Seek* - Here, to change the value of
to*Y*, the value of*20*will need to be around*X*which is one of the roots of this cubic equation.*0.**36304*

**Read More: How to Solve 2 Equations with 2 Unknowns in Excel (2 Examples)**

### 2. Using Solver Add-in to Solve Cubic Equation

Another method of solving cubic equations in Excel is the ** Solver** add-in. This add-in is an amazing tool for solving linear and nonlinear equations. Unlike

**, we can input multiple inputs in**

*Goal Seek***to see the final outcome. For a better understanding, go through the following steps.**

*Solver***Step 1:**

- First of all, make a data table for showing the results just like the previous method.
- Again, calculate the value of
from the formula shown in the previous discussion.*Y*

**Step 2:**

- Before going to the calculator we need to activate the add-in.
- For that, go to the
tab of the ribbon.*File*

**Step 3:**

- Then, select
from the*Options*window of Excel.*Home*

**Step 4:**

- Fourthly, go to the Add-ins tab in the
dialog box.*Excel Options* - Then, in the
section, choose*Manage*and then select*Excel Add-ins*.*Go*

**Step 5:**

- Fifthly, mark the box beside
and press*Solver Add-in*.*OK*

**Step 6:**

- Consequently, you will see the
command in the*Solver*group.*Data* - Then, click on it.

**Step 7:**

- In this step, you will see the
dialog box.*Solver Parameters* - Here, we have to set some parameters.
- First of all, in the
type box, select cell*Set Objective*which is the value of*C13*.*Y* - Then, set the “
” type box to*Value Of*. This sets the value of*20*.*Y* - Thirdly, we will get the output
by changing the value of*20*which is in cell*X*.*B13* - Fourthly, make sure the solving method is nonlinear as our equation is not linear.
- Lastly, press
.*Solve*

**Step 8:**

- Finally, after going through all the inputs, the
will show the final result.*Solver* - In our case, the value of
is**X**.**0.36304** - Consequently, if we enter this value into the equation we will get the value of
as*Y*.*20*

**Notes**

- As both the
and*Goal Seek*need to input a value first for the calculation, that’s why you have set the value of*Solver*in the first place.*Y = 20* - As in many cases, a cubic equation may have a simple root and more than one complex root. So, both the above methods will show the simple root as a result.

**Read More: ****Solve Algebraic Equations with Multiple Variables (3 Ways)**

## Conclusion

That’s the end of this article. We hope you find this article helpful. After reading the above description, you will be able to solve cubic equation in **Excel** by using any of the above-mentioned methods. Please share any further queries or recommendations with us in the comments section below.

The **ExcelDemy **team is always concerned about your preferences. Moreover, you need to keep in mind that the submitted comments need to be approved. Therefore, after commenting, be patient and we will reply to your queries as soon as possible.