Excel Formula for Trend

slakid

New Member
Joined
Aug 24, 2006
Messages
3
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.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

tmcfadden

Board Regular
Joined
Aug 17, 2005
Messages
151
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,992
Messages
5,545,373
Members
410,679
Latest member
rolandbianco
Top