Excel Formula for Trend

[slakid]

Is there a formulas which will look at a number of cells and return a value which relates to whether the values are increasing or decreasing at that point in time? Thanks.

 

[tmcfadden]

Look at the 'LINEST' function.

You can get the slope of a series of points from there ( you might want to also check out the 'INDEX' function to get the parameters of LINEST ).

-Tim

 

[tusharm]

If you look up XL Help for LINEST, you can then select the 'See Also' link. It will point you to a few other functions that may be relevant.

You may also want to look at
Trendline Coefficients and Regression Analysis
http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm