Daily Download 19: Solving polynomials

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 …
Polynomial Update

EvalPoly Function

Quadratic, Cubic, CubicC and Quartic functions

RPolyJT function used to solve a 60th order polynomial

Bottom of the input and output for the same function

This entry was posted in Excel, Maths, Newton, UDFs, VBA and tagged , , , , , , , , . Bookmark the permalink.

One Response to Daily Download 19: Solving polynomials

  1. Fernando says:

    Thanks very much, it´s very useful. From Spain.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s