• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to check whether the sales is growing or degrowing

R

rush2rajen

Member
Hi Excel Gurus,

Please find the attached file.
I had given what is needed in the attached file.

Please help.


Thanks
Raj
 

Attachments

  • RR.xlsx
    12.9 KB · Views: 6
Hi Rajan,

1. If diff. is positive between each successively month then positive otherwise negative. Means [+,+,+,+] implies positive and [-,-,-,-] implies nagetive and [+,-,-,+,] implies Fluctuating. Is that correct.
 
Hi Faseeh,

That's correct, but that's an array formula with CSE I think so.
Is there any simple way to get that instead of array ?
And for fluctuating it can be
[-,+,-,+,]
[+,-,-,+,]
[-,-,+,+,]
[+,+,-,-,]

But what you had done is absolutely correct.

Thanks for it but waiting for a simple way instead.

Thanks
Raj
 
You can also use the slope function to see the overall change
Change F1 to 1/7/14
then you can use: =IF(SLOPE(C2:F2,C1:F1)<0,"Negative","Positive")
etc
 
You must log in or register to reply here.
Back
Top