percentage increase/ decrease

[braddy60]

Hi

I have been given the figures in columns A &B which tallies with my formula except row 5 which has been given a 100% which is correct please.

Regards

Braddy

[tfspry]

Hi Brad - Did you intend to include an example?

Tim

[braddy60]

Hi Tim

Sorry about that now attached,

Regards

Braddy

[tfspry]

Hi

except row 5 which has been given a 100% which is correct please.

Regards

Braddy

Hi Braddy - What is meant by given a 100% ?

Will this formula work for you in all of Column D?
=IF(ISERR(B2/A2-1),"N/A",B2/A2-1)



Tim

[braddy60]

Hi Tim

I was given these figures in hard copy and was trying to see if they are correct, ie the average number of burgalaries has increase by 100% from 2.7 to 5.3

Regards

Braddy

[RetiredGeek]

Braddy,

Disclaimer: I'm no mathematician!

That said try: =IF(A5>B5,(B5-A5)/ABS(A5),ABS(A5-B5)/ABS(A5))

I entered this one and got the correct answer: 96.30% 100% would = 5.4 {2.7 *2}.
I also dragged this formula up and down w/o appreciable changes in values.

The difference is in always dividing by the same column {A} for either increases or decreases.

[tfspry]

Hi Braddy - The 2 formulas mentioned in previous posts above, produce essentially similar results. The differences between these 2 formulas are highlighted in pic below.

[attachment=89561:crime levels.jpg]

Hope that helps.

[braddy60]

Hi Tim

Many thanks it was row 5 that concerned me, with your formula it is now correct @ 96.30% whereas mine resulted in 49.06%.

Thanks to all who replied.


Braddy