Excel Growth Calculating Function

In this tutorial, we will learn about Calculating Year on Year Growth % in Excel


There is a table consisting of 3 years of sales number and I want to calculate Year on Year Growth Percentage for all 3 years.

So to calculate the growth, follow the steps given below:

1. Write = and choose the current year sales number

2. Divide it by choosing the last year sales number

3. At the end, write -1

4. Press Enter and the answer is 0.12%

5. Now, go to Home Tab and click on the Percentage symbol

6. The answer will be converted into percentage which is 12%

7. Drag the cell to the right side to get the answer of next Year on Year Growth Percentage