Interpolation Update

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:

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

4 Responses to Interpolation Update

  1. Interpolation Update is the exceptional idea. This will help the people. Definitely, i like most. Thanks.


  2. xmcarreira says:

    Thanks for sharing your codes (again)!


  3. dougaj4 says:

    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! 🙂


  4. Pingback: Daily Download 16: Intersections, interpolations, and rotations | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

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

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.