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
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 Calculate Average Percentage Change in Excel (3 Simple Ways)
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
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 Percentage Change with Negative Numbers in Excel
Similar Readings
- How to Calculate Percentage of Marks in Excel (5 Simple Ways)
- Calculate Grades with Weighted Percentages in Excel
- How to Apply Percentage Formula in Excel for Marksheet (7 Applications)
- Calculate Percentage Between Multiple Numbers in Excel
- How Do You Calculate Percentage Increase or Decrease 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. 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
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
- Compute Grades in Excel (3 Suitable Ways)
- How to Make Automatic Marksheet in Excel (with Easy Steps)
- Calculate Grade Using IF function in Excel (with Easy Steps)
- How to Calculate Price Increase Percentage in Excel (3 Easy Ways)
- Show Percentage Change in Excel Graph (2 Ways)
- How to Calculate Percentage Decrease in Excel (2 Methods)