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

calculate percentage change
=(B4-A4)/A4
 =(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.