### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Downloads
- Passing variable argument lists from Excel to Python via xlwings
- Working with units in Excel - using VBA and Python
- The angle between two vectors, Python version
- Downloads by category
- Fitting high order polynomials

### Recent Comments

# Tag Archives: Solve polynomial

## Polynomial Update

Following a comment here: Solving cubic and quartic equations with Excel the Quartic and CubicC User Defined Functions (UDFs) have been amended to fix a problem occurring with some combinations of coefficients. The updated spreadsheet (including full open source code) can be … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic, Evaluate polynomial, Excel, Jenkins-Traub, Quartic, Solve polynomial, UDF, VBA
12 Comments

## 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: http://interactiveds.com.au/software/Polynomial.zip The … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic, Evaluate polynomial, Excel, Jenkins-Traub, Quadratic, Quartic, Solve polynomial, UDF, VBA
1 Comment

## Ping Back Ping Backs

One of the nice things about writing a blog is that when people follow a link to your site you get a link to where they came from, which often leads to interesting places you would not have otherwise found. … Continue reading

Posted in Excel, Newton, VBA
Tagged Colin Legg, EE Times, links, RAD Excel, Solve polynomial
Leave a comment

## The Inverse Quadratic Method – 2

Firstly a clarification from the previous post in this series. The method presented in that post was a direct application of quadratic interpolation, rather than the inverse quadratic method, as implied by the post title. The inverse quadratic method will be … Continue reading

Posted in Excel, Maths, UDFs, VBA
Tagged Excel, quadratic interpolation, Solve polynomial, UDF, VBA
3 Comments

## Function roots with the Inverse Quadratic Method

An earlier post presented various methods for finding the roots of polynomial functions based on the use of linear interpolation. It is sometimes advantageous to use a quadratic interpolation function, and methods using this approach will be presented in this and following … Continue reading

Posted in Excel, Maths, UDFs, VBA
Tagged Excel, quadratic interpolation, Solve polynomial, UDF, VBA
5 Comments