EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Percent Change in Excel

Percent Change in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated August 22, 2023

percent Change in excel

Excel Percent Change ( Table of Contents)
  • Introduction to Percent Change in Excel
  • Examples of Percent Change in Excel

Introduction to Percent Change in Excel

Calculating Percentage seems to be a simple task for anyone who knows how to calculate percentages. You just need to divide the number value by the total and multiply it by 100 to convert it into a percentage. However, when it comes to calculating the change in percentage, it is not the task as simple as it looks to calculate the percentage. Have you ever come up with a situation where you have an old value for some variable and a new value for the same variable over a period of time? Sometimes calculating the change in percentage requires a business hour since that may affect your running business the hard way. However, sometimes this calculation is way beyond the scope of what we learned during high school. Therefore, in this article, we will teach you how to calculate the change in percentage through Excel. Well, Excel is easy to understand as well as formulate tasks, and that is what makes it a great tool over the years and forth. Let’s see how percentage change works in Excel.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

The Formula for Percentage Change in Excel

The generic formula for capturing percentage change in Excel is as follows:

=(current_value – previous_value)/previous_value

Where,

  • current_value – is a new value of the variable under consideration
  • previous_value – is an old value of the variable under consideration for calculating percentage change.

Well, the formula itself is explanatory. Since we are trying to determine the change, we must find a difference between that variable’s current and previous values. Moreover, we need to check the percentage of change that happens; we need to divide the difference between new and old values by the old value (Imagine dividing the difference by a new value. How will that look alike?).

Examples of Percent Change in Excel

Let us understand the examples of Percent Change in Excel.

You can download this Percent Change Excel Template here – Percent Change Excel Template

Example #1 – Change in Percentage

Suppose we have two numbers, 1230 and 1180, as current and previous numbers, respectively. We want to check the difference in the percentage of these two numbers under Excel. Follow the steps below to get the same.

Step 1: Open a new Excel file, and in cell A1, type the equal (=) sign to initiate a formula.

percent Change in excel 1-1

Step 2: Use the opening round bracket to start the formula. Inside the bracket, type 1230-1180 will give us the difference between current and previous numbers.

percent Change in excel 1-2

Step 3: Now, close the formula using the closing round bracket so the difference between two numbers will have a preference first in the calculation (you know the BODMAS rule, right?).

percent Change in excel 1-3

Step 4: Now, use 1180 as a value to divide this difference in values. See the screenshot given below.

percent Change in excel 1-4

Now, our formula is complete. Press Enter key to get the result for this formula. It should look like the one in the screenshot below.

percent Change in excel 1-5

This result seems to be in decimals. We wanted a result in percentages. We need to change the cell numbering property to a percentage for that.

Step 5: Select cell A1 to change the number formatting. Under the Home tab, navigate to the Number Formatting group and click on the Percentage symbol placed in that group to change the number format of cell A1 as a percentage.

percent Change in excel 1-6

This is something that you can achieve with a keyboard shortcut as well. Use Ctrl+Shift+% on your keyboard to change the cell formatting into percentage style.

You should see a result as shown in the screenshot below:

percent Change in excel 1-7

This means the percent change for the two given values is 4%.

Example #2 – Change in Percentage when Values are Stored in Cells

 In the previous example, we have seen that the numbers are used as a reference under the formula. However, what if we have thousands of numbers and want to check the percent change for those? Will it be feasible to type the formula thousands of times with changing numbers for every cell? Not, right? Suppose we have data as shown in the screenshot below. Column A contains the Current Value, column B contains the Previous Value, and column C is where we want a generic formula that captures the percent change. Follow the steps below to get the result as per our expectations:

Step 1: Inside Cell C2, start the formula using equals to sign an opening bracket.

Values are Stored in Cells 2-1

Step 2: Use the formula A2-B2 inside the bracket. Since we get a difference between the current and previous values, close the formula using the close bracket.

Values are Stored in Cells 2-2

Step 3: We need to divide this number change by the previous value to convert the result into a percentage value. Divide the bracketed quantity by B2 in cell C2.

Values are Stored in Cells 2-3

Step 4: Now, if you press Enter key, you can see a percentage change value under cell C2, as shown below:

Values are Stored in Cells 2-4

This is what a generic formula looks like. Even if we change the values for cells A2 and B2, respectively, this formula will still give the results, and you don’t need to input it again.

Step 5: Drag this formula across C3 to C6 to get the desired percent change values associated with column A and B values. You can use the keyboard shortcut Ctrl+D as well for this task. Select all the cells from C2 to C6 and press Ctrl+D on your keyboard.

Values are Stored in Cells 2-5

Step 6: Now select cells from C2 to C6 again and navigate towards the Number Formatting group under the Home tab to change the number type for these cells. We ideally wanted the formatting to be in percentage. Within that group, click on Percentage Style, and it will change the number formatting from C2 to C6 as a percentage. This can also be achieved using the keyboard shortcut Ctrl+Shift+%.

Values are Stored in Cells 2-6

The final output should look like the one in the screenshot below:

Values are Stored in Cells 2-7

This is how we can find the percentage change in Excel. That is the end of this article. Let’s wrap things up with some points to be remembered:

Things to Remember

  • Just make sure you use previous_value as a divisor to calculate the percent change. Otherwise, the results produced will be wrong.
  • #DIV/0! If you try to divide the number change by zero, an error will occur.
  • Format the result cells as Percentage Style to get a result visible in a percentage format. Excel does not automatically format the cells for you.

Recommended Articles

This is a guide to Percent Change in Excel. Here we discuss How to use Percent Change in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Sentence Case in Excel
  2. Excel Formula of Percentage
  3. Percentage Increase in Excel
  4. Format Cells in Excel
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests
 137+ Hours of HD Videos
36 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Percent Change Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

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

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

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Percent Change Excel Template

EDUCBA

डाउनलोड Percent Change Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more