FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

How to Calculate Percentage Increase in Excel?

Updated on December 28, 2023
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Calculate the Percentage Increase in Excel

Calculating the percentage increase in Excel is easy as this requires a simple formula that can be easily designed. Calculating the percentage increase shows how much there has been a change in the value but in terms of “Percentage Increase” instead of showing the delta as a “Value.”

To calculate the percentage increase, we need to formulate a function that first calculates the increase in the new value and then calculates the ratio occupied by the new value.

Percentage Increase in Excel

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: How to Calculate Percentage Increase in Excel? (wallstreetmojo.com)

Using the above excel functionExcel FunctionExcel functions help the users to save time and maintain extensive worksheets. There are 100+ excel functions categorized as financial, logical, text, date and time, Lookup & Reference, Math, Statistical and Information functions.read more, we can easily calculate the percentage increase in Excel.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Examples to Calculate Percentage Increase in Excel

Below are the following examples to calculate the percentage increase in Excel.

You can download this Calculate Percentage Increase in Excel here – Calculate Percentage Increase in Excel

Method #1 – Percentage Increase in Columns

This method should be used when we have horizontally plotted data, i.e., the data is in columns instead of rows. The common example of horizontally placed data is profit during the year, marks obtained by the student in various exams, etc.

  1. To calculate the percentage increase first, we must check whether the new value is greater than the old value or not. If there is less value than the old value, the formula may give an insignificant result.


    The data is given below:

    Percentage increase Example 1

  2. Insert the below formula in the cell and press the Enter key.


    Percentage increase Example 1-1

  3. The output is:


    Percentage increase Example 1-2

  4. Apply the formula to other cells to get the result.


    Percentage increase Example 1-6

  5. After the formula is inserted and executed, we need to format the cell to percentage to get the result as a percentage.


    Percentage increase Example 1-3

  6. We can increase the percentage, as shown below.


    Percentage increase Example 1-5

Method #2 – Percentage Increase in Rows

This method should be used when we have vertical data when the data is in a row and not in columns. The data will be in the column, but there must be only one column to use this method.

This method is useful in cases where change needs to be shown vertically. An example of this data can be the profit during various months of the same year.

  • Step #1

We can only calculate the “Percentage Increase” from the second row because there will be no base data for the first row.

Percentage increase Example 2
  • Step #2

Now, insert the below function in a row.

Percentage increase Example 2-1

We got the result as given below.

Percentage increase Example 2-2

Next, we must apply the excel formulaExcel FormulaThe term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions.read more to other cells to get the result.

Example 2-3
  • Step #3

After the function has been executed, format the cell as a percentage to get the result in a percentage.

Percentage increase Example 2-4

Method #3 – Percentage Increase in Value

This method should be used when we have only a base value, and we need to calculate a new value. It means that there is no old or new value in this case.

We have to calculate the new value by adding the defined percentage in this case. We can calculate the percentage increase between the two values, but we can also calculate the percentage increase in the same value.

  • Step #1

To calculate the percentage increase in the old value, first, we must mention the required percentage increase in a separate column.

Example 3
  • Step #2

Now, we must insert the below formula to calculate the new value that the defined percentage will increase.

Percentage increase Example 3-1

The output is given below:

calculate percentage in excel Example 3-2

Now, apply the formula to other cells to get the result.

Example 3-3
  • Step #3

Now, all we need is to format the cell as a percentage, and we will get the result in a percentage.

Example 3-4

Things to Remember

  • We can only calculate percentage increases if the data are quantitative. We cannot calculate percentages for qualitative data.
  • We can only calculate the percentage increase if the new value is greater than the old value. For a percentage increase, the value should rise and not a decline. If there is a decline in value, there will be a percentage decrease.
  • We need to format the cell as a percentage to display the result as a percentage and not a value.

Recommended Articles

This article is a guide to Calculate Percentage Increase in Excel. We discuss calculating percentage increases in Excel, practical examples, and a downloadable template. Below you can find some useful Excel articles: –

Reader Interactions

Leave a Reply

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