Results 1 to 3 of 3

Thread: Trending (2007)

  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    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
  •