You may also use the following alternate formula:
- 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.
Article ID: 214078 - Last Review: Feb 1, 2012 - Revision: 1