I would agree with the OP on this one. LINEST etc. are curve fitting
functions, not interpolating functions. Sometimes when you have a
table of data, it is easier/preferable to approximate the function as a
series of straight lines connecting the data points (similar to what a
line chart/XY chart does) rather than attempt to fit the data to a
curve.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=399062