I presume that you want to see if the OP has a new example; that would
interest me as well.

Previously posted examples include

http://groups.google.com/group/micro...9a2bb33e6cdbb8
a 6th degree polynomial fit that gets no correct figures in versions prior
to 2003, but does better in 2003 on.

http://groups.google.com/group/micro...8ea066b144d042
a 6th degree polynomial fit that gets no correct figures in any version of
Excel

http://groups.google.com/groups?thre...0a% 40phx.gbl
an orthogonal trigonometric regression that worked prior to 2003, but gives
erroneous zeros in 2003.

Jerry

"Bernard Liengme" wrote:

Agreed, there are cases when LINEST gives incorrect results.
I would be interested in seeing such a data set.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
The LINEST formulas in Excel 2002 and previous aren't as good as the
chart trendline for complex data. This is why I need to extract the
trendline data.