Excel - Interpolation amidst a listing of values

Giganews Newsgroups
Subject: Excel - Interpolation amidst a listing of values
Posted by:  TKT-Tang (tkt_ta…@hotmail.com)
Date: 30 May 2004

Amidst a long listing of multiple values,

X1 = 2.0, Y1 = 7.00 ;
X3 = 2.1, Y3 = 7.51 .

For X2 = 2.05, Y2 = ?

Please devise a worksheet formula in order to interpolate the values thereof.

Regards.

Replies