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:

Percentage Increase Formula

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 Percentage Increase.

Basic formula to Calculate Percentage Increase in Excel


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 Percentage Increase in Excel.

Using a Different Form of Percentage Increase Formula 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!

(Visited 563 times, 2 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *