Microsoft KB Archive/214078

= XL: How to Find the Percentage of Change Between Values =

Article ID: 214078

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q214078





SUMMARY
In Microsoft Excel, there is no built-in function to calculate the percentage of change from one value to another. However, you can use the following formula to calculate the percentage change

=( - )/ABS(original_value)

where  represents the value that the percentage of change is based on, and   represents the value that has changed.

You may also use the following alternate formula:

=( / )-1

To display the resulting value as a percentage value, format the cell containing the formula with a percentage format.



MORE INFORMATION
To see an example, follow these steps:   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.  With cell B4 selected, click Cells on the Format menu. On the Number tab, click to select Percentage in the Category column, and then select a percent format.

Note that the 1999 sales increased 75 percent over the sales for 1998. This is the percent of change.

Additional query words: XL2000 decrease difference xl2002 xl2001 xl97 xl98

Keywords: kbhowto KB214078

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.