MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linear interpolation


Posted by Alex Weingarten on January 24, 2002 8:52 AM

When I was using Quattro Pro, there was a very useful
function called LINTERP(known x, known y, x) where you
could interpolate a y value corresponding to x using
the XY pairs specified by the known x and known y
arrays. Is there a function that does this in Excel? I can't find it.

Alex Weingarten


Posted by Aladin Akyurek on January 24, 2002 8:55 AM

Posted by Juan Pablo G. on January 24, 2002 8:56 AM

Try TREND

=TREND(KnownY,KnownX,X)

Juan Pablo G.

Posted by Steve Hartman on January 24, 2002 9:08 AM

LINEST(known_y's,known_x's,const,stats)

Go to excel help index tab and search for LINEST for how to use this function