My internal reaction to Tushar's smug answer on this HUGE oversight with
Excel is much closer to indignation than Harlan's answer. This function
would be useful to businessmen, engineers and scientists across the spectrum.

Shame on the Excel managers for screwing up on this one. Apparently they've
lost touch. Too bad the competition isn't stronger to shake them up a little
bit.

"Tushar Mehta" wrote:

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