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

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