Ranges and functions · Shares and percent changeWorks in: all current Excel versions, Google Sheets
A share is a division
“What share of the target did each rep reach?” is the part divided by the whole: =G2/F2. The answer is a fraction like 1.04, and the cell's percentage format shows it as 104%.
Formatting only changes how a number looks. A cell formatted as 0% might show 8% while it really holds 0.0756, and every calculation uses the full 0.0756.
Common mistakes
- Dividing the wrong way round: whole ÷ part gives 0.97 instead of 1.04.
- Multiplying by 100 and using a % format: the cell then shows 10,400%.
Tap Try it to see how close each rep got to target.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Rep | Region | Jul | Aug | Sep | Target | Q3 total | Of target |
| 2 | Amara Osei | North | $12,400 | $13,100 | $11,800 | $36,000 | $37,300 | |
| 3 | Ben Fischer | South | $9,800 | $10,250 | $12,100 | $30,000 | $32,150 | |
| 4 | Lina Chen | East | $15,200 | $14,800 | $16,900 | $45,000 | $46,900 | |
| 5 | Diego Alvarez | West | $8,700 | $9,100 | $8,400 | $28,000 | $26,200 | |
| 6 | Eva Novak | North | $11,200 | $12,600 | $13,900 | $36,000 | $37,700 | |
| 7 | Farid Haddad | South | $13,300 | $12,900 | $14,100 | $39,000 | $40,300 | |
| 8 | Grace Kim | East | $10,100 | $9,600 | $10,800 | $33,000 | $30,500 | |
| 9 | Hugo Martin | West | $14,500 | $15,800 | $15,100 | $42,000 | $45,400 |
Tap Try it to type =G2/F2 into H2.
Go deeper: Percentage change, percent of total and running totals