# Thread: Trending (2007)

1. ## Trending (2007)

Loungers

I have a series of numbers extending from C3 to F3 (at this stage - but will go further) - 84, 90, 93, 96.

I trying to put together a formula at would determine what the trend of the numbers is doing - ie going up, going down or level, as you would see on a trend line on a chart and then in A3 put the corresponding text - "going up", "going down" or "level".

I hope that makes sense - any thoughts?

2. ## Re: Trending (2007)

Enter this formula in A2 (or another available cell):

=SLOPE(C3:F3,COLUMN(\$C:\$F))

Adjust the range as needed. This formula returns the slope of the trend line. Then, in A3, enter the formula

=IF(A2<-0.05,"Down",IF(A2>0.05,"Up","Level"))

Adjust the "sensitivity" as desired - this version reports "Level" for slopes between -0.05 and +0.05.

3. ## Re: Trending (2007)

Hans - Sorry about the delayed response - Thanks for your help again - will give it a go

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•