### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Downloads
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- COM624 download and documentation sites
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Cubic Splines

### Recent Comments

# Tag Archives: polynomial solution

## Solving the Lagrangian Point equation for the Moon

This post was prompted by a recent question at Fitting high order polynomials, asking for Excel methods to solve the equations for the radius of the Moon’s Lagrangian Point 1. All the methods described in this post have been added to … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Excel, iterative solution, Lagrangian point, Newton, polynomial solution, UDFs, VBA
3 Comments

## Linest, NPV, IRR and solving polynomials

In a comment on Using LINEST for non-linear curve fitting Lori Miller posted a formula that found the coefficients fitting a cubic polynomial curve to a set of data, then solved the resulting equation to find the X value for a given … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Excel, IRR, Jenkins-Traub, NPV, polynomial solution, UDF, VBA
3 Comments