Year-on-year growth generally refers to the growth rate compared to the same period of the previous year.
The formula is:Year-on-year growth rate = (current period - base period) base period * 100% = (current base period - 1) * 100%.
For example, there is a fruit sale**, where A is listed as the month and B is listed as the fruit sales;Cell B2 is 200 kg of fruit sales in January 2023 and cell B3 is 100 kg of fruit sales in January 2022. Cell B4 is counted as year-over-year growth.
Enter the formula in cell B4=text((b2-b3)/b3*100%,"0.00%")
So, fruit sales in January 2023 increased by 100% compared to January 2022.
The text function is used here to convert the numbers to a percentage format.
The text function is used in Excel to format numbers as text and can be displayed in the specified format.
The syntax is text(value,format text).
value is the number to be converted, and format text is the format you want. "0.00%"RepresentativesFormat it as a percentage and keep it to two decimal places
You can also enter it in cell b4 without using the text function=(b2-b3)/b3*100%
Directly click the percentage style in the Start tab to convert the format.
The software and hardware models and app versions used in this operation demonstration are as follows:
Hardware model: Mac mini;
Software version: macOS Sonoma 142；
App version: Microsoft Excel for Mac v1644。
Excel function formulas
15 commonly used excel function formulas, from beginner to proficient.