Calculate Percent Change in Excel

Add to Favorites

How to calculate the percentage amount that a value has changed in Excel. This includes quickly calculating this value for an entire list.

Sections:

The Formula

Steps in Excel

Compare Each Value to the First in a List

Notes

The Formula

The formula to calculate the change is simple:

(Value2-Value1)/Value1

Steps in Excel

Enter the above formula in Excel:

You will get a whole number value like this:

Select the cell with the formula and go to the Home tab and click the percent % button in the Number group.

If you are in a version of Excel before 2007 or just want a quick alternative, you can use the keyboard shortcut Ctrl + Shift + % to format the cell as a percentage.

If you have a list of numbers, like in this example, you can copy the formula down to get the percentage change between each row. Just select the cell with the formula and double-click the bottom right-hand corner of the cell or click and hold that corner and drag it down.

Compare Each Value to the First in a List

If you want to return the percentage change between each value and the first value, we need to make the cell reference for cell A1 absolute; that means that the cell reference will not change as the formula is copied down the list.

The new formula would look like this:

=(A2-$A$1)/$A$1

Notice the dollar signs for the A1 cell references that were not there in the previous example.

Copy the formula down and format it as a percentage and we get this:

Now each percentage change is relative to the first number in the list, 10.

To learn more about cell references, check out our tutorial on absolute and relative cell references in Excel. This will help you make much more powerful formulas.

Notes

Much of what you do in Excel will be modifying real-world math formulas like in this tutorial. The trick is to get those formulas to work with and for the data that we have in the spreadsheet. This tutorial was meant to give you more of an idea of how you can do that, rather than just to teach you the formula for calculating a percentage change.

Don't forget to format the output as a percentage; Excel does not usually automatically do this for you.

Make sure to download the sample file for this tutorial so you can work with these examples in Excel.

 


Downloadable Files: Excel File

Similar Content on TeachExcel
Stop Formula Calculation in Excel - Increase Worksheet Performance
Tutorial: I'll show you how to stop formulas and functions from performing their calculations and u...
Run a Macro When a Specific Cell Changes in Excel
Tutorial: Run a macro in Excel when a specific cell is changed; this also covers when a cell within...
Filter Data in Excel to Show Only the Top X Percent of that Data Set - AutoFilter
Macro: This Excel macro filters a set of data in Excel and displays only the top X percent of tha...
Filter Data to Show the Bottom X Percent of the Data Set in Excel - AutoFilter
Macro: This free Excel macro filters data to display the bottom X percent of the data set in Exce...
Filter Data to Show the Top 10 Percent of the Data Set in Excel - AutoFilter
Macro: This Excel macro filters a set of data in Excel to display only the top 10 percent of that...
Increment a Value Every X Number of Rows in Excel
Tutorial: How to increment a value, number, percent, etc. every so many rows in Excel. This tutorial...