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.