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
