Excel 2007 : GROWTH Function

[darbary]

Dear Senior Members,

Can anyone guide me as to how does one calculate “GROWTH” in Excel Worksheets?
In high risk (Short Term) stock selection, I would like to select those companies that have shown a “Loss to Profit” in say Latest Quarter or Latest Financial Year.
And I would like to even RANK them.
For example say latest Quarter the PAT (Profit After Tax) is Rs.100 & the earlier Quarter the PAT is Rs.110. Then we would calculate by using the formula =(110-100)/100 to get 10% GROWTH.

But how does one calculate GROWTH when there was say loss (PAT) in the earlier Quarter. (Say -1) & Latest Quarter the PAT is 100?
And the next Question is according to me I would RANK higher if say loss (PAT) in the earlier Quarter is say -100 & latest Quarter the PAT is 200.
I need to work on a spread sheet containing over 1000 such stocks having Quarterly PAT Values.
My 3rd Question would be what if there was no profit & no loss say if the PAT is Zero in the earlier Quarter?

[alansidman]

Does the attached work for you?

Alan

[darbary]

Thanks Alan,

I think it may work.