How to Calculate Growth Percentage with Formula in Excel

Method 1 – Calculating Growth Percentage Between Two Numbers in Excel

To show this process, let’s assume we have a dataset of products with sales records for the last two years. Now we will find out the sales increase in percentages between two years using the below formula:

= (Current Sales / Previous Sales) – 1

Steps:

  • Select the first cell E5 of Increase of Sales and enter the following formula:
=(D5/C5)-1
  • Hit Enter.

inserting formula to show how to calculate growth percentage formula in excel

  • Copy down the formula up to E10.

  • Right-click on the output range and select Format Cells.
  • A prompt will appear on the screen.

formatting cells to show how to calculate growth percentage formula in excel

  • Select the Percentage option under Category.
  • Change the Decimal places of the percentage.
  • Click OK.

using format cells prompt to show how to calculate growth percentage formula in excel

  • All the values on the E column will be converted into percentages.

calculating growth percentage between two numbers to show how to calculate growth percentage formula in excel

Note:

You can convert the values easily using the following steps:

  • Go to Home Tab.
  • Go to the Number section and select the % option. 
  • Increase or decrease the decimal places by clicking that option.


Method 2 – Calculating Growth Percentage Increased by a Specific Percentage in Excel

Here we will show how to increase some values with a constant. For this, I will be using the formula below:

= Total Amount * (1+Specific Percentage (%))

Let’s consider a data set of a product list and its price. Now we will calculate the cost of each product after 15% VAT.

Steps:

  • Enter the following formula in D5:
=C5*(1+15%)
  • Hit the Enter button.

  • Copy down the formula for the other cells up to D10.

Read More: How to Calculate Sales Growth Percentage in Excel


Method 3 – Calculating Original Price by Using Growth Percentage

Let’s assume we have to extract the original value from any given dataset where products are listed with their percent change and current price.  Using the following formula, we will calculate the original price:

= Current Price / ( Percent + 1 )

Steps:

  • Enter the formula below in cell E5:
=D5/(C5+1)
  • Hit Enter.

inserting formula to show how to calculate growth percentage formula in excel

  • Copy down the formula up to E10.

calculating original price to show how to calculate growth percentage formula in excel

Read More: How to Use the Exponential Growth Formula in Excel


Method 4 – Calculating Growth Percentage Between Yearly Total Sales Data in Excel

Let’s consider a product dataset with its yearly total sales. We will show how to calculate the growth percentage between yearly total sales data in Excel using the same formula used in method 1, but it will be row-wise. The formula will be:

= (Current Sales / Previous Sales ) – 1

Steps:

  • Insert the formula below in the second cell D6 of the Growth Percentage column.
=(C6-C5)/C5
  • Hit Enter.

entering formula to show how to calculate growth percentage formula in excel

  • Use the fill handle to copy the formula to the other cells.

calculating growth percentage on yearly basis to show how to calculate growth percentage formula in excel

  • Select all the cells and go to the Home tab.
  • Click on the % sign under the Number option.

  • All the values will be in a percentage format.


Method 5 – Calculating Final Annual Growth

Let’s have data on the yearly sales of any company. Now we will calculate the annual growth rate in percentage. We can calculate the final growth in two ways.

  • Calculating Final Compound Annual Growth Rate in Excel
  • Calculating Final Average Annual Growth Rate in Excel

Case 5.1 Calculating Compound Annually Final Growth Rate in Excel

Here I will calculate the final compound annual growth rate using this formula.

=((End Value/Start Value)^(1/Periods) -1

Steps:

  • Type the following formula in the E5 cell:
=(C10/C5)^(1/(6-1))-1
  • Press Enter.

  • We will get the annual final growth percentage. But not in a percentage format.

  • Go to the Home tab.
  • Choose the % sign under the Number option.

  • We will get the annual growth rate in a percentage format.

Read More: How to Calculate Monthly Growth Rate in Excel


Case 5.2 Calculating Average Annually Final Growth Rate in Excel

Consider the same example above, but here we will calculate the average annually final growth rate using the below formula:

= (Last Value – First Value) / First Value

Steps:

  • Calculate the Average Growth Rate in the D column using this formula below in cell D6:
=(C6-C5)/C6
  • Hit Enter.

  • Autofill the rest of the cells. We will get the annual growth values.

  • Go to the Home tab.
  • Below the Number option, select the % sign.

  • Select the F5 cell and write the following formula,
=AVERAGE(D6:D10)
  • Hit Enter.

  • We will get the average annual growth percentage rate.

Read More: How to Calculate Sales Growth over 3 Years in Excel


How to Calculate Percentage Decrease in Excel

Steps:

  • Select E5 and write the following formula down,
=(D5/C5)-1
  • Hit Enter.

  • Autofill the rest of the cells.

  • Select all the result cells.
  • Go to the Home tab.
  • Select the % sign under the Number option.

  • All the data will be transformed into percentage formats.


Download the Practice Workbook


Related Articles


<< Go Back to Growth Formula In Excel | Excel Formulas for Finance | Excel for Finance | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdullah Al Murad
Md. Abdullah Al Murad

Md. Abdullah Al Murad is a computer engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in C, C++, Python, JavaScript, HTML, SQL, MySQL, PostgreSQL, Microsoft Office, and VBA and goes beyond the basics. He holds a B.Sc. in Computer Science and Engineering from American International University-Bangladesh. He has transitioned into the role of a content developer. Beyond his work, find... Read Full Bio

3 Comments
  1. Reply
    Md Sabbir Hossain Jun 16, 2021 at 5:52 PM

    Thanks for sharing. Very informative article.

  2. Thank you! This is exactly what I needed!

    • Dear Elizabeth,

      You are most welcome. We are so glad that our article fulfilled your need.

      Regards
      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo