Another update to IP.xls

Following some suggestions from Mike Seymour I have modified my polyline intersection function, and added a new version. The changes are:

  • The data ranges for the new function, IP4(), are entered as four separate ranges, so the X and Y values do not need to be in adjacent columns.
  • For both IP() and IP4() the data may now be arranged in rows, rather than columns.  If the data ranges have more than 2 columns for IP(), or more than 1 column for IP4(), it is assumed that the data is arranged row-wise.

The new spreadsheet may be downloaded from:

The spreadsheet also includes a number of geometric and interpolation functions.  As usual, full open-source code is included n the download.  See for a full list.

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

1 Response to Another update to IP.xls

  1. 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 )

Twitter picture

You are commenting using your Twitter 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.