Percentage Change Formula in Excel

Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Percentage Change Excel Formula

We can do arithmetic calculations via Excel formulas. One such calculation is “percent change” from one value to another. For example, suppose you want to find the percentage change between your first drawn salary and your current salary. In that case, that will be calculated in terms of the percentage change. It is possible in formulas in Excel. This article will discuss calculating the percentage change formula in excel.

Percentage-Change-Formula-in-Excel.png

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Percentage Change Formula in Excel (wallstreetmojo.com)

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

What Is the Percentage Change in Excel?

A percentage change or percentage variance is the change between two values over time. For example, a specific percentage change is the “variance between last year’s sales and this year’s sales.”

For example, last year’s sale was $400,000. This year, sales are $450,000, so the difference is a $50,000 increase in revenue. But we can also tell this percentacge-wise.

So, to calculate the percentage change between two numbers is below.

(Current Value – Previous Value) / Previous Value

Else, we can also use the below formula.

Current Value / Previous Value – 1

In the above example, the previous year’s sales were $ 400,000, and current-year sales were $450,000. So, let us apply these numbers to the formula.

(Current Value – Previous Value) / Previous Value

= (450000 – 400000) / 400000

= 50000/400000

= 12.5 % increase in Revenue.

Examples

Now, we will see how we can apply the same formula in Excel.

You can download this Percentage Change Formula Excel Template here – Percentage Change Formula Excel Template

Example #1

Below is the quarterly sales data for the previous and current years of ABC Co. Pvt Ltd.

From this data, we need to determine the variance percentage from the previous quarter to this year’s quarter.

Let us use our formula, as we have learned above. However, we will use cell referencesUse Cell ReferencesCell reference in excel is referring the other cells to a cell to use its values or properties. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1.read more instead of entering the numbers directly into the formula.

Copy the above table to an Excel sheet.

percentage change formula example 1

Now, put an equal sign in cell D2 because all the formulas in Excel must start with an equal sign only.

percentage change formula example 1-1

Open the bracket, and our first formula should be the current value. In this example, the current value is the C2 cell value.

percentage change formula example 1-2

Then, put the minus (-) sign and choose the previous year’s value,B2 cell.

percentage change formula example 1-3

Close the bracket and put it divided by a symbol by inserting a forward slash.

percentage change formula example 1-4

Now again, select the previous year’s value.

percentage change formula example 1-5

Press the “Enter” key to get the result of the percentage change from the previous year to this year.

percentage change formula example 1-6

We got only decimal values. For this, we must apply the percentage format. To use the percentage format, select the cell, and press the percentage (%) symbol.

percentage change formula example 1-7

We can also press Ctrl + Shift + % as a shortcut key to apply percentage change. We can see the percent change values as soon as we use the percentage format.

percentage change formula example 1-8

First, the percent change is 33.59%, the current revenue is 21611, and the previous revenue is $16,177. So revenue has increased from previous to this current year. So it increased by 33.59%.

Similarly, the second value percent change is -1.25% and revenue decreases.

Use the formatting code below to apply the red color format to a negative percent change.

0.00%;[Red]-0.00%

percentage change formula example 1-9

Example #2

Below are employees’ salary details and their current salary when they joined.

percentage change formula example 2

Let us use the same formula above to find the variance percent change between these two numbers.

Example 2-1

As we can see in cell D6, we got the error value because whenever we divide the number by zero, we get the division error value as #DIV/0!Error Value As #DIV/0!#DIV/0! is the division error in Excel which occurs every time a number is divided by zero. Simply put, we get this error when we divide any number by an empty or zero-value cell.read more.

So to get rid of this, we need to use the IFERROR function in excelUse The IFERROR Function In ExcelThe IFERROR function in Excel checks a formula (or a cell) for errors and returns a specified value in place of the error.read more.

Example 2-2

The first argument of this function is value. So for this, apply the percent change formula as usual.

Example 2-3

The second argument is value if error.It says what should be the value if the supplied calculation returns as the error value, so we need the result to be 0%.

Example 2-4

Now see, we got rid of the error value because of the IFERROR function.

Example #3

Below is the sales employee’s revenue generation comparison from last month to this month.

Example 3

Below is the sales employee’s revenue generation comparison from last month to this month.

Current Value / Previous Value – 1

Example 3-1

So, only two employees performed better than the previous month, D3 and D5 cells.

Things to Remember

  • We must always use cell references to make the formula dynamic.
  • When dividing the value by zero, we may get a division error of #DIV/0!.
  • We must use the IFERROR function to get rid of error values.

This article is a guide to the Percentage Change Formula in Excel. We learned how to calculate the percentage change formula in Excel along with examples and a downloadable Excel template. You may learn more about Excel from the following articles: –