# How to Calculate Percentage Change in Excel

**Calculate percentages**

**how to calculate percentage change in excel**

**Note:**this methods working with : Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel Online

**how to calculate percentage change in excel**Sometimes percentages can be frustrating because it’s not always easy to remember what we learned about them in school. Let Excel do the work for you – simple formulas can help you find the percentage of a total, for example, or the percentage difference between two numbers.

**how to calculate percentage change in excel**Find the percentage of a total

**how to calculate percentage change in excel**Say that your company sold $125,000 this quarter, and you need to find out what percentage $20,000 is of the total.

**how to calculate percentage change in excel****1.**To find out, divide $20,000 by $125,000. Here’s the formula in cell C2: =B2/A2. The result is shown as 0.16 because cell C2 is not formatted as a percentage.

**how to calculate percentage change in excel**

**how to calculate percentage change in excel****2.**To format 0.16 as a percentage, (which will also remove the zero) on the Home tab, click the Percentage button.

**how to calculate percentage change in excel**If you are using Excel Online, click Home > Number Format > Percentage.

**how to calculate percentage change in excel**

**how to calculate percentage change in excel**Now we see that $20,000 is 16% of $125,000.

**how to calculate percentage change in excel**

**how to calculate percentage change in excel**Find the percentage of change between two numbers

**how to calculate percentage change in excel**A company sold $485,000 in 2011 and $598,634 in 2012. What’s the percent change between the two years?

**how to calculate percentage change in excel****1.**First, click in cell B3 to apply the Percentage format to the cell. On the Home tab, click the Percentage button.

**how to calculate percentage change in excel**If you are using Excel Online, click Home > Number Format > Percentage.

**how to calculate percentage change in excel****2.**In cell B3, divide the second year’s sales ($598,634.00) by the first year ($485,000.00), and then subtract 1.

**how to calculate percentage change in excel**

**how to calculate percentage change in excel****3.**Here’s the formula in cell C3. =(B2/A2)-1. The percentage of change between the two years is 23%.

**how to calculate percentage change in excel**Notice the parentheses around (B2/A2). Excel calculates what’s in parentheses first, and then subtracts the 1.

## No comments: