Calculate percentage change
BeginnerPercentage change helps you describe growth (or decline) relative to the starting point. It is commonly used to compare periods. For example to compare this year to last year.
In this sheet, quarterly revenues are listed for last year and this year. You will total each year, then calculate percentage change for each quarter and for the yearly total.
What you need to do
- Click cell B6 (Total last year).
- Calculate the total of B2:B5.
- Click cell C6 (Total this year).
- Calculate the total of C2:C5.
- Click cell D2 and calculate % change for Q1 using this pattern:
- (new value - old value) / old value
- Fill the same formula down through D5.
- In D6, calculate % change for the totals using C6 and B6.
- Press Enter.
Goal
- Cells B6 and C6 should show the yearly totals.
- Cells D2:D5 should show quarterly % changes.
- Cell D6 should show the percentage change for the total (about 7.27%).
Need some help?
Hint 1
The old value is in column B and the new value is in column C, so your percentage change formula in column D should reference B and C in the same row.
Hint 2
Start in D2, then reuse the same pattern in D3:D5 by filling down.
Hint 3
Use SUM for the totals, B6 should be 550,000 and C6 should be 590,000, then D6 should be close to 7.27%.
Calculate percentage change
BeginnerPercentage change helps you describe growth (or decline) relative to the starting point. It is commonly used to compare periods. For example to compare this year to last year.
In this sheet, quarterly revenues are listed for last year and this year. You will total each year, then calculate percentage change for each quarter and for the yearly total.
What you need to do
- Click cell B6 (Total last year).
- Calculate the total of B2:B5.
- Click cell C6 (Total this year).
- Calculate the total of C2:C5.
- Click cell D2 and calculate % change for Q1 using this pattern:
- (new value - old value) / old value
- Fill the same formula down through D5.
- In D6, calculate % change for the totals using C6 and B6.
- Press Enter.
Goal
- Cells B6 and C6 should show the yearly totals.
- Cells D2:D5 should show quarterly % changes.
- Cell D6 should show the percentage change for the total (about 7.27%).
Need some help?
Hint 1
The old value is in column B and the new value is in column C, so your percentage change formula in column D should reference B and C in the same row.
Hint 2
Start in D2, then reuse the same pattern in D3:D5 by filling down.
Hint 3
Use SUM for the totals, B6 should be 550,000 and C6 should be 590,000, then D6 should be close to 7.27%.