Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate quarter-over-quarter growth in Excel and Google Sheets
Heads up: Excel and Google Sheets do this differently.
Excel
=((C2-B2)/B2)*100Google Sheets
=ARRAYFORMULA(IF(B2:B<>'', ((C2:C-B2:B)/B2:B)*100, ''))✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Q1 Sales | Q2 Sales | QoQ Growth |
| 1200 | 1500 | |
| 1800 | 1900 | |
| 2200 | 2400 |
=((C2-B2)/B2)*100→-100
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter your quarterly data into two adjacent columns, with the earlier quarter in the first column and the later quarter in the second column.
- 2In the third column, input the formula to calculate QoQ growth.
- 3Copy the formula down to apply it to all relevant rows.
Tips
- Ensure your data is formatted as numbers to avoid errors in calculations.
- If your dataset includes missing values, adjust your formula to handle them appropriately.
- Remember to format the resulting percentages for better readability.
Need the Google Sheets version instead? Open Sheets variant in workspace →
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What if my data spans multiple years?
The same formula applies. Just ensure the quarters are in chronological order.
Can I use this formula for other types of data, not just financial metrics?
Yes, the QoQ growth formula can be used for any numerical data where you want to measure percentage change over quarters.
How do I format the result as a percentage?
Select the cell with the formula, right-click, choose 'Format Cells', then select 'Percentage' in Excel or use the percentage button in the toolbar in Google Sheets.