Excel + Google Sheets · % change
The growth formula every report needs
New minus old, divided by old. Format the cell as %.
The formula
=(C2-B2)/B2What each part means
C2-B2How much it changed/B2Compared with the start
Example
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | 2025 | 2026 | Change |
| 2 | Jan | 1,000 | 1,250 | |
| 3 | Feb | 800 | 720 | |
| 4 | Mar | 1,500 | 1,800 |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | 2025 | 2026 | Change |
| 2 | Jan | 1,000 | 1,250 | +25% |
| 3 | Feb | 800 | 720 | -10% |
| 4 | Mar | 1,500 | 1,800 | +20% |
Step by step
- Click cell D2.
- Type the formula:
=(C2-B2)/B2 - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English % change
- Español % de variación
- Português % de variação