Remember Me?

#1
January 23rd 06, 03:51 PM posted to microsoft.public.excel.worksheet.functions
 Ration Posts: n/a
Excel formula that calculates percentage of increase or decrease

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?

#2
January 23rd 06, 04:00 PM posted to microsoft.public.excel.worksheet.functions
 Ron Rosenfeld Posts: n/a
Excel formula that calculates percentage of increase or decrease

On Mon, 23 Jan 2006 07:51:03 -0800, Ration
wrote:

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?

=(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
#3
January 23rd 06, 04:10 PM posted to microsoft.public.excel.worksheet.functions
 BekkiM Posts: n/a
Excel formula that calculates percentage of increase or decrease

=(B2-A2)/A2

Where A2 is your original number (12) and B2 is your new number (16)

"Ration" wrote:

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post MEGTOM New Users to Excel 5 October 27th 05 03:06 AM gordo Excel Worksheet Functions 14 October 18th 05 05:19 PM sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM Romany Excel Discussion (Misc queries) 3 June 1st 05 07:02 PM vijay Excel Discussion (Misc queries) 0 May 20th 05 06:27 AM

All times are GMT +1. The time now is 03:47 AM.