Use the percent change formula in Excel. Learn how to quickly calculate the percentage change easily in Excel. This simple calculation can be used in a slew of applications. Let’s quickly review the syntax.

**Syntax**

=(Current Year-Previous Year)/Previous Year

**Percent Change Formula Example**

=(B4-A4)/A4

In this example, we are trying to find the percent of change between 2019 sales and 2018 sales. Using our formula, we calculate the percent change is +28% growth. This formula also works inversely for decreased growth.