View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BekkiM
 
Posts: n/a
Default 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?