% of Increase - Decrease - Formula

**Desert Piranha** · 09-18-2006, 09:45 PM

Hi all,

Simplified:
I have a this years total in A1, last years total in B1, difference +/- in C1

$1000.00___$800.00___+$200.00___+%
$800.00___$1000.00___<$200.00>___<%>

I am trying to get a % of Increase/Decrease (Between A1 and B1) in D1.
Not as a dollar amount but as a %.

I have tried Percentile and PercentRank and some other stuff. No joy.

Any direction?

**mudraker** · 09-18-2006, 10:29 PM

with column D format set to percentage try

=(A1/B1)-100%

**Desert Piranha** · 09-18-2006, 11:44 PM

Originally Posted by mudraker

with column D format set to percentage try

=(A1/B1)-100%

Hi Mudraker,

Its working good. Not being a math person, i had a hard time getting my head
around the difference in the +/- results, with the same input values, but they
are correct.

IE:
YTD__LY___%
25___50___-50.0%
50___25___100.0%

Why do you subtract the -100% in your formula?

Thanks a lot.

**mudraker** · 09-20-2006, 03:36 AM

I am no maths/Excel expert either so i can not fully explain why Without the -100% Excel gives a % increase of 125% when it is 25%. using your 1st example of $1000.00___$800.00___+$200.00___+% but I will try

$1000 is 1.25 times greater than $800 when expressed as a % this comes out as 125%.
Subtracting 100% gives the actual increase. of 25%