Engineering Interpolation x to y?


Posted by Dick on February 02, 2002 1:38 PM

Hi,

If you will excuse the word, QuattroPro, has a very
nice function that will interpolate (like reading
a graph) to produce an interpolated Y for example
if the two columns of selected cells were:
2 2
4 6
9 9

and you entered 3.1, the answer would come back 4.2

Has anyone seen a canned add-on function for Excel that
does this kind of interpolation?

Thanks



Posted by Steve Hartman on February 05, 2002 10:36 AM

=trend()