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 from how we generally do it. In this article, we will show you how to solve cubic equation in Excel.

## How to Solve Cubic Equation in Excel: 2 Ways

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 Y**

*Solver***and then, by using that value, we will solve for X in Excel.**

*,*For our calculation process, we’ve arranged the equation on a worksheet like the following image. Here, we have shown the variables and the coefficients 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:**

- Firstly, 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 solve an equation for X when Y is given.
- 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 Polynomial Equation in Excel

### 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, make a data table to show 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*

**Read More:** How to Solve an Equation for X When Y is Given in Excel

**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.
- Firstly, 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*

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

**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:** How to Solve Polynomial Equation in Excel

**Download Practice Workbook**

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

## 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.

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.

## Related Articles

- How to Solve for x in Excel
- How to Solve Algebraic Equations with Multiple Variables
- How to Solve System of Equations in Excel
- How to Solve Simultaneous Equations in Excel
- How to Solve Nonlinear Equations in Excel
- How to Solve Differential Equation in Excel
- How to Solve Exponential Equation in Excel
- How to Solve Colebrook Equation in Excel
- How to Solve Quadratic Equation in Excel VBA

**<< Go Back to Excel Solve Equation | ****Excel Solver Examples | Solver in Excel | Learn Excel**