• 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

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