We’ve arranged the equation on a worksheet using the following image for our calculation process. Here, we have shown the variables and the coefficients separately.

### Method 1 – Utilizing the Goal Seek Feature to Solve a Cubic Equation in Excel

**Steps:**

- Make a new table under the main data set to show the results after calculation.
- Set
as the initial value of*0*.*X*

- 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`

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

- After finishing all the calculations, go to the
group of the ribbon.*Forecast* - Choose the
**What-If****Analysis**.

- From the dropdown menu, select
.*Goal Seek*

- 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* - In the “
” type box, input the cell address that will be the final output of this goal.*Set cell* - In the “
” type box, set the new output for the cell chosen in the previous step.*To value* - In the “
” type box, select the cell, and we will get the above outcome by altering it.*By changing cell* - Press
.*OK*

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

**Read More: **How to Solve Polynomial Equation in Excel

### Method 2 – Using Solver Add-in to Solve a Cubic Equation

**Steps:**

- Make a data table to show the results, just like the previous method.
- Calculate the value of
from the formula shown in the previous discussion.*Y*

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

- Select
from the Excel*Options*window.*Home*

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

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

- Mark the box beside
and press*Solver Add-in*.*OK*

- You will see the
command in the*Solver*group.*Data* - Click on it.

- You will see the
dialog box.*Solver Parameters* - We have to set some parameters.
- In the
type box, select cell*Set Objective*which has a value of*C13,*.*Y* - Set the “
” type box to*Value Of*. This sets the value of*20*.*Y* - Get the output
by changing the X value in cell*20*.*B13* - Ensure the solving method is nonlinear, as our equation is not linear.
- Press
.*Solve*

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

- After reviewing all the inputs, the
will show the final result.*Solver* - In our case, the value of
is**X**.**0.36304** - 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, 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.

**Read More:** How to Solve Polynomial Equation in Excel

**Download the Practice Workbook**

You can download the free Excel workbook here to practice.

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