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 onward since we need a minimum of two percentage values to calculate the increase. That’s why **cell H5** is kept unoperated.

## Download Practice Book

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

In this article, I will show you **how to calculate the average percentage increase** for marks in **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** and 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**.

- Then, by clicking the
**ENTER**button, we can find the increased value in**fraction**. After that, we need to follow the following steps to get it in**percentage**form.

- Go to
**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 decrease for marks** in this **Excel** sheet.

This is how we can easily** calculate the average percentage increase** in **Excel **by using the **Basic Formula Method**.

**Read More:** **How to Apply Percentage Formula in Excel for Marksheet (7 Applications)**

### 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 will follow the following steps.

- 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, here why **cell H9 **is representing the **negative value** is discussed earlier in the **very first method** of this article.

**Read More: ****How to Calculate Grades with Weighted Percentages in Excel**

**Similar Readings**

**Calculate Letter Grades in Excel (6 Simple Ways)****How to Calculate Percentage of Marks in Excel (5 Simple Ways)****Calculate Average Percentage in Excel [Free Template+Calculator]****How to Calculate Grade Percentage in Excel (3 Easy Ways)****How to Calculate Total Percentage in Excel (5 Ways)**

### 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**. To do so, we need to follow the following steps.

- 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, here why **cell H9 **is representing 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 (4 Methods)**

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

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

## Related Articles

**How to Calculate Subject Wise Pass or Fail with Formula in Excel****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)****How to Make Automatic Marksheet in Excel (with Easy Steps)****Compute Grades in Excel (3 Suitable Ways)****Calculate Percentage in Excel Based on Cell Color (4 Methods)****Calculate Grade Using IF function in Excel (with Easy Steps)****How to Calculate Revenue Growth Rate in Excel (3 Methods)**