Today we will discuss another important topic on how to calculate the average percentage increase for marks in Excel formula. Here, we took an Excel sheet that represents *ADAM*â€™s average percentage of marks in 5 different terms where each subject carries 100 marks. To represent the information Iâ€™ve taken 7 columns. These are *Name, Terms, Physics, Chemistry, Mathematics, Avg. % (Average Percentage), *and *Avg. % Increase (Average Percentage Increase)* respectively. We will calculate the average percentage increase from cell *H6* to downward since we need a minimum of two percentage values to calculate the increase. Thatâ€™s why cell *H5 *is kept unoperated.

**Table of Contents**Expand

## How to Calculate Average Percentage Increase for Marks in Excel Formula: 3 Easiest Ways

In this article, I will show you how to calculate the average percentage increase for marks using the Excel formula in 3 different and easiest ways.

### 1. Calculate Average Percentage Increase in Excel by Using Basic Formula Method

In this method, we will discuss the basic formula method to calculate the average percentage increase for marks in Excel.

- To start that method, we need to select cell
**H6**first.

- Now, we need to apply the following formula.

`=(G6-G5)/G5`

**Formula Explanation**

Here,

**G6-G5**Â represents the difference between the two averages in

*Terms 1*and

*2*. Thatâ€™s why we need to divide it by

**G5**to calculate our desired average percentage increase.

- By clicking the
**ENTER**button, we can find the increased value in fractions. - Go to the
**Home**tab**>>**Select**%***(Percentage)*icon.

Immediately after selecting the **% ***(Percentage)* option from the **Home** tab, we can see there appears the average percentage increase in percentage form.

- After that, use
**Fill Handle**to**AutoFill**the formula for the rest of the cells to get the average percentage increase of marks in Excel.

Here, we can see a negative percentage in cell** H9**, which means the average percentage decreases for marks in this Excel sheet.

**Read More: **How Do You Calculate Percentage Increase or Decrease in Excel

### 2. Calculate Average Percentage Increase in Excel by Using Alternative Basic Formula Method

This one is all the same as the previous method. But here, we will use that formula in a different way and for this.

- We need to select cell
**H6**.

- Now, we need to apply the following formula.

`=G6/G5-1`

**Formula Explanation**

Here,** G6/G5** represents the respective average increase between *Terms 1 *and *2.* Thatâ€™s why we need to subtract it by 1 to calculate our desired average percentage increase.

- Then, by clicking the
**ENTER**button, we will find our desired increased value.

- After that, use
**Fill Handle**to**AutoFill**the formula for the rest of the cells to get the average percentage increase of marks in Excel.

Eventually, we will be able to find the average percentage increase for all the *Terms* in this Excel sheet. Note that, why cell** H9 **represents the negative value is discussed earlier in the very first method of this article.

**Read More: **How to Calculate Price Increase Percentage in Excel

### 3. Calculate Average Percentage Increase in Excel by Using SUM Function

We can also calculate the average percentage increase in Excel by using **the SUM function**.

- We need to select cell
**H6**.

- Now we need to apply the following formula.

`=SUM(G6-G5)/G5`

**Formula Explanation**

Here, **SUM(G6-G5)** represents the difference between the two averages in *Terms 1* and *2.* Thatâ€™s why we need to divide it by **G5** to calculate our desired average percentage increase.

- Then, by clicking the
**ENTER**button, we will find our desired increased value.

- After that, use
**Fill Handle**to**AutoFill**the formula for the rest of the cells to get the average percentage increase of marks in Excel.

Eventually, we will be able to find the average percentage increase for all the *Terms* in this Excel sheet. Note that, why cell** H9 **represents the negative value is discussed earlier in the very first method of this article.

**Read More:** How to Calculate Percentage Increase from Zero in Excel

## Practice Section

Iâ€™ve given a practice sheet in the workbook to practice these explained ways to calculate the average percentage increase in Excel. You can download it from the link given above.

**Download Practice Book**

## Conclusion

In this article, I have tried to explain 3 different ways to calculate the average percentage increase in Excel. Note that, you can also calculate the average percentage decrease too in Excel by just following the same methods. Last but not least, I will be extremely grateful if you comment down below any of your suggestions, ideas, or feedback.

**<< Go Back to Percentage Change |Â Calculating PercentagesÂ | Calculate in Excel | Learn Excel**