The interpolation functions in IP2.xls have been given an overhaul:
- The linear and quadratic interpolations routines have been modified to accept negative values.
- All the routines have been modified to convert the table range to an array, rather than using a range object.
- Notes and an example of the InterpA function have been added.
The new file can be downloaded from the link above, and as usual includes full open source code.
Also note that a variety of other interpolation and curve fitting functions are available in: