Today’s download provides analytic solutions to polynomial equations up to fourth order (that is quadratic, cubic and quartic equations) and an iterative method to solve equations of higher order. All these functions are found in the download file:
The links below describe these functions in more detail. Several of the earlier links refer to other download files, but all of the functions are now included in the Polynomial.xlsb spreadsheet.
Solving cubic and quartic equations with Excel
Evaluating Polynomial Functions
Complex Numbers and Solving Quartic Polynomial Equations
Solving higher order polynomials
Evaluating higher order polynomials …