2 Ways to Calculate Percentage Increase in Excel
A Percentage Increase is when you increase an amount by a certain percentage. Generally, we calculate the Percentage Increase with the help of an old value and a new value. In Microsoft Excel, calculating Percentage Increase is very similar to how you did it in your school days. In this article, I will show you 2 ways to calculate the Percentage Increase in Excel.
Introduction to the Dataset
Here is the dataset for this particular article. It describes the sales of a laptop shop. You can see the number of sales (column B) increased slightly each month (column A) from January to July. I’ve also added a column for the results (column C) of the monthly Percentage Increase.
Percentage Increase Formula
The equation for calculating the Percentage Increase:
You can use any of the formulas above, both are okay. While using the formulas in Excel, one thing to remember is you don’t need to multiply 100 in the formulas. Because Excel already has a built-in option to apply percentages with any values. Simply, just click on it.
Quickest Way to Calculate Percentage Increase in Excel
The most convenient way to calculate the Percentage Increase is to follow the basic Percentage Increase formula.
Syntax
=(New value/Old value) - 1
Formula
=B3/B2 - 1
Usage Guide
Step_1: First, Keep the top cell of column C empty, and type the formula in cell C3.
The reason I have kept the top cell of column C (cell C2) empty is that there was no previous value before that.
Step_2: Then, press ENTER to insert the formula.
Step_3: Now click on cell C3 to select it.
Step_4: After that, click on the Home tab.
Step_5: From the Number group, hit the Percentage (%) icon.
Step_6: Now double-click on the Fill Handle icon at the bottom-right corner of cell C3 to copy down the formula.
Final Result >
This method is pretty fast and really easy to remember to calculate the Percentage Increase.
Formula Explanation
- B3 is the new value.
- B2 denotes the old value.
Alternative Way: Use a Different Form of Percentage Increase Formula
This alternative method adopts a different structure of the basic Percentage Increase formula.
Syntax
=(New value - Old value)/Old value
Formula
= (B3-B2)/B2
Usage Guide
Step_1: First, keep the top cell of column C empty, and type the formula in cell C3.
Step_2: Then press ENTER to insert the formula into cell C3.
Step_3: Now select cell C3.
Step_4: Then click on the Home tab.
Step_5: Select the Percentage % icon under the Number group.
Step_6: Now double-click on the Fill Handle of cell C3 to fill down the formula applied.
Final Result >
Like the first way, this formula functions perfectly. You can use either way to calculate the Percentage Increase in Excel.
Formula Explanation
- B3 is the new amount of sales.
- B2 represents the old sales.
Conclusion
I believe you now have a clear understanding of the three ways to calculate Percentage Increase in Excel. I truly hope that this article will help you in resolving any scenario with a Percentage Increase. Furthermore, If you’re interested in reading more articles like this one about Excel, check out our Blog page. And, please feel free to comment below with your comments on our content. Have a good day!
Related Articles
- How to Calculate Total Revenue in Excel [Free Template]
- How to Calculate Profitability Index in Excel [Free Template]
- How to Find Interquartile Range (IQR) in Excel [Free Calculator]
- 2 Ways to Calculate Cumulative Frequency in Excel
- Calculate Percentage of a Number in Excel [4 Cases Explained]
- Calculate 3 Types of Profit Margin in Excel