Percent Change Formula in Excel

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.


=(Current Year-Previous Year)/Previous Year

Percent Change Formula Example

calculate percentage change

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.

Leave a Reply

DSUM Function

The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria. =DSUM

Read More »

WORKDAY Function

The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user

Read More »
Scroll to Top