We can input arbitrary values for those parameters on our spreadsheet. Next type in the formula A22 in cell B2. In the below picture we calculate the roots of the quadratic functions.
Set cell is the formula cell It should be automatically selected To value should be 0 which is the right end of the.
Solve Quadratic Equation in Excel using Formula The format of a quadratic equation is x -b b2-4ac2a. Using Goal Seek to solve quadratic equations in Excel. Since we know the formula representation and the values we can now create a formula for solving quadratic equations. See the second image in part a The quadratic polynomial of degree 2 model is y -00006x2 10694x 11586 The graphs show that the quadratic equation is the better model and follows the data more closely.