Linear Interpolation UDF

[Guest]

Does anyone have a good UDF for linear interpolation?

I want something like

Linterp(KnownXs, KnownYs, NewX)

It will find and use the two points surrounding NewX and linearly
interpolate the Y-value. If NewX is beyond the range of KnownXs, then it
will use either the first or last two to extrapolate an answer.

Please note, I am not asking you to make one for me, I would assume that
many people have already made one for themselves. Also I am not interested
in the LINEST, FORECAST, or TREND functions. They are not the same as linear
interpolation. I know you can use FORECAST if you have the two points you
want to use, but I would like to be able to pick the entire list of X's and
Y's.

 

[MartinW]

The following links have what you ask.

http://www.sulprobil.com/html/interpolate.html
http://www.tushar-mehta.com/excel/newsgroups/interpolation/index.html

Despite what you say LINEST, FORECAST and TREND are the same as
linear interpolation and IMHO are, when used correctly, better than UDF
and VBA solutions.

HTH
Martin

 

[Guest]

Thank you for the quick response.

The following links have what you ask.

http://www.sulprobil.com/html/interpolate.html
http://www.tushar-mehta.com/excel/newsgroups/interpolation/index.html

Despite what you say LINEST, FORECAST and TREND are the same as
linear interpolation and IMHO are, when used correctly, better than UDF
and VBA solutions.

HTH
Martin