### 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 Sale****s**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.

- SelectÂ the
**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 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**.

- 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 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**.

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

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

- All the values will be in a percentage format.

**Read More: **How to Calculate Revenue Growth Rate in Excel

**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
**E****5**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**

- How to Calculate Dividend Growth Rate in Excel
- Growth Formula in Excel with Negative Numbers
- How to Calculate Sales Growth over 5 Years in Excel
- How to Calculate Year over Year Growth with Formula in Excel
- Growth Over Last Year Formula in Excel

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

Thanks for sharing. Very informative article.

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