You are currently offline, waiting for your internet to reconnect

Excel: How to Find the Percentage of Change Between Values

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q214078
SUMMARY
In Microsoft Excel, there is no built-in function to calculate thepercentage of change from one value to another. However, you can usethe following formula to calculate the percentage change
=(new_value-original_value)/ABS(original_value)
where original_value represents the value that the percentage of change is based on, and new_value represents the value that has changed.

You may also use the following alternate formula:
=(new_value/original_value)-1
To display the resulting value as a percentage value, format the cellcontaining the formula with a percentage format.
MORE INFORMATION
To see an example, follow these steps:
  1. In a new worksheet, type the following values:
       A1: Sales for 1998     B1: Sales for 1999   A2: $100,000           B2: $175,000   A4: Percent Change     B4: =(B2-A2)/ABS(A2)						
    If you use the alternate formula, type the formula =(B2/A2)-1 in cell B4.
  2. With cell B4 selected, right click and choose the Format Cells menu.
  3. On the Number tab, click to select Percentage in the Category column, and then select a percent format.
Note: The 1999 sales increased 75 percent over the sales for 1998. This is the percent of change. 
decrease difference xl2003 xl2007 xl2010
Properties

Article ID: 214078 - Last Review: 02/01/2012 21:57:00 - Revision: 6.0

Microsoft Office Excel 2003, Microsoft Office Excel 2007, Microsoft Excel 2010

  • kbhowto KB214078
Feedback
/c.gif?DI=4050&did=1&t=">