WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Percentage Change Formula in Excel

Percentage Change Formula in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Percentage Change Excel Formula

Arithmetic calculations can be done via excel formulas, and one of such calculation is “Percent Change” from one value to another. For example, if you want to find the percentage change between your first drawn salary and current salary, that will be calculated in terms of percentage change, so this is possible in formulas in excel. In this article, we will discuss how to calculate the percentage change formula in excel.

Percentage Change Formula in Excel

What is the Percentage Change in Excel?

A Percentage Change or Percentage Variance is the changes between any two values over a period of time. A typical example of a percentage change example is “variance between last year sales and this year sales.”

For example, last year’s sale was USD 400000, and this year, sales are 450000, so we can tell the difference is USD 50000 increase in revenue, but we can tell this in percentage-wise as well.

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

(Current Value – Previous Value) / Previous Value

Or else we can also use the below formula as well.

Current Value / Previous Value – 1

In the above example, previous year sales were USD 400000, and current-year sales are USD 450000, so let’s 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 of the previous year and current year of an ABC Company Pvt Ltd.,

From this data, we need to find out what is the variance % from the previous year quarter to this year’s quarter.

Let’s use our formula, as we have learned above. This time we are going to use cell references instead of entering the numbers directly into the formula itself.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Copy the above table to an excel sheet.

percentage change formula example 1

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

percentage change formula example 1-1

Now open the bracket and our first formula should be Current Value, and in this example, the current value is C2 cell value.

percentage change formula example 1-2

Then put minus (-) sign and choose Previous Year Value, i.e., B2 cell.

percentage change formula example 1-3

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

percentage change formula example 1-4

Now again, select Previous Year Value.

percentage change formula example 1-5

Hit the enter key to get the result of percentage change from the previous year to this year.

percentage change formula example 1-6

We got only decimal values; for this, we need to apply the percentage format. To apply the percentage format, select the cell, and hit the percentage (%) symbol.

percentage change formula example 1-7

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

percentage change formula example 1-8

First, the percent change is 33.59%, i.e., current revenue is 21611, and the previous revenue is 16177, so revenue has been increased from previous to this current year, so it is increased by 33.59%.

Similarly, the second value percent change is -1.25%, i.e., revenue is decreasing.

To apply the red color format to a negative percent change, apply below formatting code, as shown below.

0.00%;[Red]-0.00%

percentage change formula example 1-9

Example #2

Below are the salary details of employees when they joined and current salary.

percentage change formula example 2

To find out the variance percent change between these two numbers, let’s use the same formula as above.

Example 2-1

As we can see in cell D6, we got the error value; this is because whenever we divide the number by zero, we get division error value as #DIV/0!.

So to get rid of this, we need to use the IFERROR function in excel.

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; this 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

This time apply the second formula we have learned, i.e., Current Value / Previous Value – 1

Example 3-1

So only two employees have better performance than the previous month, i.e., D3 & D5 cell.

Things to Remember

  • Always use cell references to make the formula dynamic.
  • When you divide the value by zero, we get a division error of #DIV/0!.
  • Use the IFERROR function to get rid of error values.

Recommended Articles

This has been a guide to Percentage Change Formula in Excel. Here we learn how to calculate percentage change formula in excel along with examples and downloadable excel template. You may learn more about excel from the following articles –

  • Write Formula in Excel
  • What are Auditing Tools in Excel?
  • Calculate the Percentage Increase in Excel
  • Advanced Excel Formulas
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Percentage Change Formula Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More