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.

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.

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