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.
Interpolation Function Examples
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:
Newton Excel Bach, not (just) an Excel Blog 
Interpolation Update is the exceptional idea. This will help the people. Definitely, i like most. Thanks.
LikeLike
Thanks for sharing your codes (again)!
LikeLike
Xosé – Glad you find the things here useful!
Incidentally, on your site, if you could change the last two letters of the text for link here from US to Aus, it would be more accurate! 🙂
LikeLike
Pingback: Daily Download 16: Intersections, interpolations, and rotations | Newton Excel Bach, not (just) an Excel Blog