![in excel continue an equation for many rows in mac in excel continue an equation for many rows in mac](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/05/Add-multiple-rows-Example-1-1.png)
![in excel continue an equation for many rows in mac in excel continue an equation for many rows in mac](https://cdn.ablebits.com/_img-blog/debug-formulas/allow-editing-in-cells.png)
Just after typing the equation in cell G3, click on to solver which is under the Analysis option of the Data tab.Let`s solve the previous equation for a better understanding. You can also use the Solver feature of Excel to solve cubic equations.
![in excel continue an equation for many rows in mac in excel continue an equation for many rows in mac](https://media.idownloadblog.com/wp-content/uploads/2020/09/Excel-Mac-Select-Sheet.jpg)
Solve Cubic Equation in Excel using Solver Now the initial value is showing the value of X when the value of Y becomes 15. After the Goal Seek completes its operation you will see the initial value of X and the cell where the formula was placed is changed.The Goal Seek feature will do some iterations for the final value of Y which is set as 15 in this example.In the Goal Seek dialogue box, insert the inputs as follows and press on OK.Now, under the Data tab click on to the Goal Seek option under the Forecast option.After that write the polynomial equation in cell G3 with respect to the cells of coefficients and the initial value of X.Set the initial value of X as “0” in cell B6.First set the coefficients in different cells.We will use the Excel Goal Seek feature here to solve the equation. We will solve this equation for finding the value of “X” with a specific value of “Y”. Let`s say we have a cubic equation which is Y=5x 3-2x 2+3x-6. Read More: 3D Referencing & External Reference in Excel Solve Cubic Equation in Excel using Goal Seek With the direct calculation method, we will also discuss other methods like Goal Seek, Array, and Solver in this article to solve different polynomial equations. Different kind of polynomial equations example is given below. The Polynomial equations don’t contain a negative power of its variables. Further Readings Solving Polynomial Equations in ExcelĪ polynomial equation/function can be quadratic, linear, quartic, cubic, and so on.