Calculating Increase/Decrease

Seems overly complicated. Why not just b4/c4 and set the result to %?

Hi Druid9855

One simply cannot divide B4/C4

I need to calculate the increase in % one year over the other for Eg if Profits are 95415 in Jan 2008 and 80215 in Jan 2008 , then the % Increase will be (95415-80215)/80215 *100

I can calculate the formula for this , but the problem comes where for eg there is a loss in Jan 2008 for -95415 and there was a profit in Jan 2007 for 80215. How do I set up formula to take negatives & positives into account in calculating the increase or decrease/

Your assistance or anybody's on the forum will be greatly appreciated

Regards

Howard

Howard

The calculation that you are using is taking into account the minus figures already.

If you take the case of Branch 2 - it has moved from a loss of 112,560 to a profit of 43,720.The difference between the 2 performances is (-112,500+43,720)=156,280, when this is expressed as a percentage of 112,500 it is 138.8% improvement.

edvwvw

Hi EDVWVW

Thanks for your reply.

Look at the % for branch5 it is incorrect. I would like a formula that will take all the factors in my sample which I posted to calculate the % increase(Decrease)

Your assistance will be most appreciated

Regards

Howard