Math formula
Percentage change in Excel and Google Sheets
Calculate growth or decline between two numbers as a percentage.
Syntax
=(new - old) / old- new
- The latest value.
- old
- The earlier value.
Example
| Row | A | B | C |
|---|---|---|---|
| 1 | Last year | This year | Change |
| 2 | 80,000 | 92,000 |
C2 =(B2-A2)/A2
Result: 15%
Growth from 80,000 to 92,000. Format the cell as a percentage.
Ready-to-copy formulas
Avoid errors when old is zero
=IFERROR((B2-A2)/A2,"")Share of total
=B2/SUM($B$2:$B$10)Margin
=(B2-C2)/B2
Tips
- Format the result as %, don't multiply by 100.
Need the whole spreadsheet?
Start from a free template with every formula already in place. Opening a template uses no credits.