MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Engineering Interpolation x to y?

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


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?


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