As nice as it would be for MS to meet every need for every function
from every customer, XL is flexible enough to allow one to add new
capabilities.

For a few options for piecewise linear interpolation, see a discussion
"Graph look up" in .excel.charting. You can search the google.com
archives of the XL newsgroups for a post by Dave Braden for code based
on cubic splines and visit www.xlrotor.com for code based on Bezier
curves.


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , =?Utf-
8?B?RGFuIEdhdXRoaWVy?= <Dan says...
Please add this function which may be used either for a vector set of data or
for a 2 dimensional array of data.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions