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.

Copy down the formula up to E10.

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

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

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

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 formulainD5:

=C5*(1+15%)

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.

Copy down the formula up to E10.

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 datasetwith 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 D6of the Growth Percentage column.

=(C6-C5)/C5

Hit Enter.

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

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.