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.
0 kommentar(er)
