You may want to calculate the average percentage change inย **Excel** to determine the growth or decline of your company annually or to predict the profits for the following year. The rate of change in percentage for each time slot over a span of time is given to us by the average percentage change. Weโll walk you through 1 simple approach in this article to figure out the calculation of the average percentage change in **Excel**.

Letโs say your dataset contains information about your companyโs profits from the preceding 12 years. You now wish to figure out the yearly average percentage change in your companyโs profit. You will see exactly how to achieve it in the portion that follows.

**Contents**hide

## ๐ย Download Excel File

Download free Excel workbook from here:

## What is Average Percentage Change?

To begin, letโs define what an average percentage change is before calculating one. The average percentage change is the cumulative average of each termโs increase or decrease.

The time frame can be expressed in any time slot, such as a day, month, year, etc. The average percentage change is also referred to as the average yearly growth or reduction rate when the period is within a year. The compound annual growth or reduction rate is a different kind of yearly growth or reduction rate.

The cumulative impact is taken into account when calculating the compound annual growth or reduction rate, and each yearโs growth or reduction is multiplied in the year after. It may be a useful method for determining your investment returns. When a yearโs growth or decline is unrelated to that of the prior year, the average annual growth or decline rate is employed. A companyโs profit growth or decrease can be estimated using its average yearly growth or reduction rate or simple average percentage change.

The general formula that you can use to calculate the percentage change is:

**Percentage Change in a time frame = (Profit at the end of the time โ Profit at the initial time)/ย Profit at the end of the time**

And if you want the formula average percentage change then this one is for you.

**Average Percentage Change = Summation of percentage change in all the times/ Number of times**

## Learn to Calculate Average Percentage Change in Excel with AVERAGE Function

While writing this article, โHow to Calculate Average Percentage Change in **Excel**โ, weโve considered a dataset that contains approximately **6** columns and **17** rows. In this dataset, we added **Years**, **Profit**, **Percentage Change**, and **Average Percentage Change** to make you better understand. But if you want, you can change the entities and put your own values.

Computing the percentage change is the prerequisite to calculating the average percentage change in **Excel**. We ought to know the figure from the prior year in order to calculate the percentage change. However, for the first year, we cannot access the data from the year before. Therefore, we must determine the percentage change from our datasetโs next year. We will do this by applying theย **AVERAGEย **function ofย **Excel**.

โฌ๏ธโฌ๏ธ **STEPS** โฌ๏ธโฌ๏ธ

- Primarily, you need to select cell
**D7**. - Secondly, write the following formula on that cell.

**=(C7-C6)/C6**

- Thirdly, press
**Enterย**key.

- Fourthly, use the
**fill handle**to drag the formula to the entire column. - Consequently, you will get the
**Percentage Change**for each cell.

- Then we added the decimal values after the values below the
**Percentage Change**ย heading.

- Belatedly, you have to select cell
**F6**. - Then you will write the given formula on that cell.

**=AVERAGE(D6:D17)**

- Finally, tap the
**Enterย**key. - Eventually, you will get the required result you wanted.

Undoubtedly, you can simply follow this method to calculate the average percentage change in **Excel**.

**๐ Read More: ****6 Ways to Solve When Average Formula is Not Working in Excel**

## Average Formula Using VBA in Excel

Using **VBA **in **Excel** is unquestionably a good technique to achieve any calculation in **Excel**. If you want to determine the average formula in **Excel **using **VBA **then this part is for you. We will show you how to calculate the average formula using **VBA **in **Excel **step by step. Just follow the given instructions to obtain the formula.

โฌ๏ธโฌ๏ธ **STEPS** โฌ๏ธโฌ๏ธ

- Primarily, go to the
**Excelย**worksheet. - Secondly, press
**Alt**+**F11**. - Then you will get a
**VBA**window in front of you. - Thirdly, you need to insert a
**Module**.

- After that, you will get a module there.
- Fourthly, write the following code on that module.

**Code**

```
Sub Average_Formula_VBA()
Dim p As Worksheet
Set p = Worksheets("Average Formula")
p.Range("E6") = Application.WorksheetFunction.Average(p.Range("C6:C17"))
End Sub
```

- Afterward, select
**Run**and press**Run Sub/UserForm**or simply**F5**key. - Consequently, you will get the required result you wanted.

Truly, this is a convenient approach to calculating the average formula in **Excel **using **VBA**.

**๐ Read More: ****4 Ways to Calculate Average, Minimum, and Maximum in Excel**

## Percentage Increase or Decrease Formula in Excel

In **Excel**, you can determine the percentage increase or decrease formula easily. According to the **Excel** rule, if the percentage increases then the value will be **Positive**,and if the percentage decreases then the value will be **Negative**. We will show this to you in this section with some appropriate steps.

โฌ๏ธโฌ๏ธ **STEPS** โฌ๏ธโฌ๏ธ

- Primarily, you need to select cell
**D7**. - Secondly, write the following formula on that cell.

**=(C7-C6)/C6**

- Then press
**Enterย**key.

- Fourthly, use the
**fill handle**to drag the formula to the entire column. - Here, the
**Positive**value refers that the percentage has increased and the**Negative**value refers that the percentage has decreased.

Thatโs how you can determine the percentage increase or decrease formula in **Excel**.

**๐ Read More: ****7 Quick Ways to Calculate Average Percentage Increase in Excel**

## How to Calculate Salary Increase Percentage in Excel

If you want to calculate your salary increase percentage in **Excel** then you are in the right place. Salary increase percentage means the percentage increase of the salary this year compared to the previous year. We will do the exact thing that you need. To calculate the increased percentage of the salary in **Excel**, the first thing is to determine the initial salary, payment type, annual salary, etc. which we have given here from cells **B5 **to **C9**. follow the given steps to achieve this process.

โฌ๏ธโฌ๏ธ **STEPS** โฌ๏ธโฌ๏ธ

- Initially, select cell
**C11**. - Secondly, write the formula on that cell.

**=C8+C9**

- Now press the
**Enterย**key. - This is the
**Latest Salary**that we have calculated.

- Fourthly, select cell
**C12**. - Afterward, put the following formula there.

**=(C11-C8)/C8**

- After that, tap
**Enterย**button. - Finally, you will get the desired salary increase percentage as required.

Truly, this process is very simple to calculate your salary increase percentage in **Excel**.

**๐ Read More: ****6 Quick Ways to Calculate Average Percentage of Marks in Excel**

## ๐ Important Notes

You should be aware of the following things while performing the processes mentioned above:

๐๏ธย You need to be careful while applying the **AVERAGE** function in **Excel**.

๐๏ธย You should be conscious when you intend to use the **VBA** code.

## ๐ Takeaways from This Article

If we summarize the whole article, we have got some points.

๐ย Initially, we defined the average percentage change in **Excel**.

๐ย Secondly, we used the **AVERAGE **function to calculate the average percentage change in **Excel**.

๐ ย Thirdly, we applied **VBA **to determine the average formula in **Excel**.

๐ย Afterward, we determined the percentage increase or decrease formula in **Excel**.

๐ย Finally, we showed you how to calculate the salary increase percentage in **Excel**.

## Conclusion

We wish that you would be able to calculate the average percentage change in the **Excel** formula using this article. As we have shown you a very easy method, you can easily follow this without any hesitation. If you have any skepticism, feel free to ask me in the comment. In the end, to learn more about **Excel** tactics, we recommend you to visit our website **www.ExcelDen.com**.

## Related Articles

**7 Easy Ways to Calculate Average Rating in Excel****3 Approaches to Calculate 5 Star Rating Average in Excel****7 Ways to Calculate Average Attendance with Formula in Excel****2 Easy Ways to Compute Average Excluding 0 in Excel****3 Approaches to Calculate Average of Text in Excel**