Excel formula that calculates percentage of increase or decrease

R

Ration

I'm pretty new to Excel and I need a formula that calculates the percentage
of increase or decrease between 2 numbers. For example if the first number is
12 and the second number is 16, this is a 33% increase over the original
number (12). Is there a formula that incorporates this calculation?
 
R

Ron Rosenfeld

I'm pretty new to Excel and I need a formula that calculates the percentage
of increase or decrease between 2 numbers. For example if the first number is
12 and the second number is 16, this is a 33% increase over the original
number (12). Is there a formula that incorporates this calculation?
Click to expand...

=(16-12)/12

or

=(SecondNumber - FirstNumber) / FirstNumber

If your FirstNumber is in A1, and your SecondNumber in A2, then:

=(A2-A1)/A1

For a nicer looking result, format the cell with your formula as Percent with
the desired number of decimal places.
--ron
 
Top