## What Is Percent Change In Excel?

Percent Change in Excel, as the name suggests helps users find the changes between two values (old value and new value) in the data.

For example, ABC Co. achieved a revenue of $15K in the previous week. However, the current week’s revenue is $20K. What is the percentage change in revenue compared to the last week?

In this example, we have two numbers: previous week and current week. As per the formula, the old value is the previous week’s number, and the new value is the current week’s number.

**Percent Change = (New Value – Old Value) / Old Value**

**Percent Change = (20,000 – 15,000) / 15,000****Percent Change = 5,000 / 15,000****Percent Change = 33.33%.**

We can do the same calculation by using simple Excel formulas. Now, we will see how to solve these problems in an Excel worksheet.

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: Percent Change In Excel (wallstreetmojo.com)

##### Table of contents

### Key Takeaways

- Percent change in Excel is used to find the difference between two values. The two values must be the old and new value of a particular data.
- The percent change formula in Excel is calculated by Percent Change = (New Value – Old Value) / Old Value OR Percent Change = New Value / Old Value – 1.
- A minimum of two numbers are required to calculate percentage change.
- The percentage change can be positive or negative, and it is essential to use a red color format for negative percentage changes.

### Syntax

The syntax of percent change in Excel is

**Percent Change = (New Value – Old Value) / Old Value**

**OR**

**Percent Change = New Value / Old Value – 1**

### How To Calculate Percent Change In Excel?

We need at least two numbers from different periods to calculate the percent change in Excel. Below is the formula to calculate the percent change in general.

### Examples

#### Example #1

Below is the revenue every year for the past 10 years.

So, from this data, we need to find the year on the year percentage change in revenue. Then, copy the above data to a worksheet.

Here, the first-year percentage change is nil because to compare that year’s number, we need the previous year’s number, so it is unavailable. From the second year onwards, we can calculate the percentage difference in excelPercentage Difference In ExcelPercentage difference in Excel finds the percentage changes, fluctuations, and the percentage value of any number. For percentage difference, subtract the smallest number from the largest and divide the output with the smallest number.read more.

Apply the basic excel formulaBasic Excel FormulaThe term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions.read more as (New Value – Old Value) / Old Value.

It will calculate the percentage change in revenue between 2008 and 2009.

So, revenue has decreased by -15.75% from 2008 to 2009.

Copy and paste the formula to the remaining cells to see the year on percent change.

Apply the below formatting to see the negative percentage in red color.

We get the following result.

It is one way of finding percentage change year on year. Another way of finding the percentage change is between the base year (first year) and the remaining year.

For this, our formula’s old value remains the same for years. In this data, the old value is the year 2008.

Apply the above formula to the remaining cells to see the percentage change between the first year and last year.

So, from the first to last year, revenue has decreased by 20.98%. But, on the other hand, the revenue increased only in 2016 by 10.08%, which is the highest.

#### Example #2

We have seen how to calculate the percentage change between two values. Now, we will see how to increase the number by a certain percentage.

Assume you are working in HR. You have received a salary increment percentage after appraisal. You have a current salary, and also, you are provided with what percentage hike is given. Using this, you need to calculate a new salary.

This example is slightly different from what we have seen in the above example. Here, we need to increase the number by a certain percentage.

Below is the formula to increase the value by a certain percentage.

**New Salary = Current Salary * (1 + Percentage Increase)**

Apply the same logic for the below data as well.

We get the following result.

Apply the formula above to all the cells to get the new salary value.

Let me explain to you how this formula works.

The first formula reads like this B2*(1+C2)

= 27323*(1+4.5%)

= 27323*(1.045)

= 28553.

#### Example #3

Consider the below table showing the salary of people in an organization.

Now, let us learn the method to find the percent change in Excel.

The steps are:

**Step 1:** To start with, select the cell to insert the formula. In this example, let us select cell D2.

**Step 2:** Next, insert the percent change in Excel.

The formula is =B2*(1+C2)

**Step 3:** Press Enter key. We can see the result as shown in the below image.

Next, using Autofill option, we can find the result in the cell range, D3:D9.

Likewise, we can find percent change in Excel.

### Important Things To Note

- The percentage change requires at least two numbers.
- The percentage changePercentage ChangePercentage Change can be defined as a % change in value due to changes in the old number and new number and the values can either increase or decrease and so the change can be a positive value (+) or a negative value (-). read more could be positive as well as negative.
- We must always apply a red color format for negative percentage change.

### Frequently Asked Questions

**1. How to graph percent change in Excel?**

To enable percent change charts, go to the ‘General’ tab and select the ‘Enable’ check box. Then, under ‘Percent Change Chart,’ choose ‘Show Calculation Point Marker’ to display the anchor bar.

**2. How to calculate percent change in Excel between two cells?**

To calculate percent change in Excel, consider the below example.

Select cell C1 to find the result. Enter the old and new values in cell A1, use the formula =((A2-A1)/A1)*100 in cell A3.

Press the ‘Enter’ from the keyboard.

Likewise, we can find percent change in Excel.

**3. How do you calculate percent change with negative numbers?**

To calculate a percent difference using negative numbers, first determine the negative values. Then, calculate the difference between the two negative values, the average of the negative values, divide by the average, and convert to a percentage.

### Download Template

This article must be helpful to understand the **percent change in excel**, with its formula and examples. You can download the template here to use it instantly.

### Recommended Articles

This article is a guide to Percent Change in Excel. We discuss how to calculate percent change using a formula in Excel along with some examples and a downloadable Excel template. You may learn more about Excel from the following articles: –

- Calculate the Percentage Increase in ExcelCalculate The Percentage Increase In ExcelPercentage increase = (New Value - Old Value)/ Old Value. Instead of showing the delta as a Value, percentage increase shows how much the value has changed in terms of percentage increase.read more
- Percentage Excel FormulaPercentage Excel FormulaThe percentage is calculated as the proportion per hundred. In other words, the numerator is divided by the denominator and the result is multiplied by 100. The percentage formula in Excel is = Numerator/Denominator (used without multiplication by 100). To convert the output to a percentage, either press “Ctrl+Shift+%” or click “%” on the Home tab’s “number” group. read more
- Percentile Excel FormulaPercentile Excel FormulaThe PERCENTILE function is responsible for returning the nth percentile from a supplied set of values. read more
- Percent Error Excel FormulaPercent Error Excel FormulaPercentage error formula is calculated as the difference between the estimated number and the actual number in comparison to the actual number and is expressed as a percentage, to put it in other words, it is simply the difference between what is the real number and the assumed number in a percentage format.read more