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



Juan Pablo G.

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


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