Linear Interpolation

[Patrick Connor]

I would like to use in Excel a function like the one
in Corel Quattro Pro (@LINTERP)
What I need is a funtion that does
interpolation for a series of ranges
for known x and known y s.
I don't want to have to write a different
formula for each segment that has a different slope

 

[Bob Buckland ?:-\)]

Hi Patrick,

You may want to also post this in the MS Excel newsgroup,
news://msnews.microsoft.com/microsoft.public.excel and
include the version of Excel you are using in your post.
In Excel help you may want to search on trendlines


========
I would like to use in Excel a function like the one
in Corel Quattro Pro (@LINTERP)
What I need is a funtion that does
interpolation for a series of ranges
for known x and known y s.
I don't want to have to write a different
formula for each segment that has a different slope >>
--
I hope this helps you,

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

The Office 2003 System parts explained
http://microsoft.com/uk/office/preview/system.asp