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
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:
To display the resulting value as a percentage value, format the cell containing the formula with a percentage format.
To see an example, follow these steps:
- In a new worksheet, type the following values:
If you use the alternate formula, type the formula =(B2/A2)-1 in cell B4.
A1: Sales for 1998 B1: Sales for 1999
A2: $100,000 B2: $175,000
A4: Percent Change B4: =(B2-A2)/ABS(A2)
- With cell B4 selected, right click and choose the Format Cells menu.
- On the Number tab, click to select Percentage in the Category column, and then select a percent format.
The 1999 sales increased 75 percent over the sales for 1998. This is the percent of change.