Not only is LINEST a misleading name but the documentation is also
equally misleading. For more on how to get the coeffients for various
types of trendlines see
Trendline coefficients
http://www.tushar-mehta.com/excel/ti...efficients.htm
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
Does anyone know if there are functions available in or for Excel that return
the coefficents of logarithmic and polynomial trendlines, analogous to
Slope(...) and Intercept(...) for linear trendlines?
Thank you.
Sprinks