Calculating Increase/Decrease

[howard]

I have a spreadsheet which has the current months data in column B and the previous month data in column C. The % increase/decrease is in column D.

My Formula in column D needs to be amended. As can be seen The Increse/Decrese % in cell D8 is incorrect.

Your assistance will be most appreciated

Howard

Book3
	A	B	C	D
1
2
3	TotalNetProfit	NPJan2008	NPJan2007	%Increase/(Decrease)
4	Branch1	49,145	27,025	81.85%
5	Branch2	43,720	(112,560)	138.84%
6	Branch3	(53,075)	39,045	-35.93%
7	Branch4	1,530,274	1,169,112	30.89%
8	Branch5	(26,042)	39,458	34.00%
Sheet1

 

[druid9855]

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

 

[howard]

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

 

[edvwvw]

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

 

[howard]

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