Statistical
Period-over-Period Growth Rate
Calculate the growth rate (percentage change) between consecutive periods. Essential for tracking month-over-month, quarter-over-quarter, or year-over-year performance.
Excel Formula
=(A3-A2)/A2*100Step-by-Step Explanation
1
A3 is the current period value
2
A2 is the previous period value
3
(A3-A2) is the absolute change
4
Dividing by A2 converts to a relative change
5
Multiplying by 100 gives the percentage
6
Positive = growth, Negative = decline
Example
| Month | Revenue (A) | Growth % (B) |
|---|---|---|
| Jan | $10,000 | — |
| Feb | $12,000 | 20% |
| Mar | $11,400 | -5% |
| Apr | $14,000 | 22.8% |
Result: =( A3-A2)/A2*100 → 20% growth from Jan to Feb
Common Variations
As decimal
=(A3-A2)/A2Returns 0.2 instead of 20
Year-over-year
=(A14-A2)/A2*100Compare to same month last year (12 rows back)
Average growth rate
=AVERAGE(B3:B13)Average monthly growth rate
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →