How to calculate the formula for year-on-year (how to calculate year-on-year)

Hello everyone, Lin Fei to answer the above questions, year-on-year how to calculate the formula, how to calculate the same period of time, many people do not know, now let's take a look!

1. First, what is year-on-year growth?

2. How to calculate the year-on-year growth rate in excel is actually not complicated. The key is to understand what year-on-year growth is and its formula.

3. Knowing these, what we need to do in excel is to put the specific data cells into the formula.

4. What is the year-on-year growth? Year-on-year growth refers to the growth rate compared to the previous, annual, or historical growth rate.

5. The year-on-year growth rate is calculated as follows: year-on-year growth rate = (this year-last year) / 100% last year

6. 2. Examples of the formula for calculating the growth rate of the same period last year

7. Let's use a simple example to illustrate how to calculate the year-on-year growth rate in excel. As shown in the picture below, A2 is last year's sales, B2 is this year's sales. We need to calculate the year-on-year growth rate of cell C2.

8. We apply the year-on-year growth formula and slightly modify it in excel to get the formula = TEXT ((B2-A2) / A2'0'), and then calculate the year-on-year growth rate.

At the end of this article, I hope it will be helpful to you.