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:

Powered by Blogger.