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.

ABCDEFGH
1RepRegionJulAugSepTargetQ3 totalOf target
2Amara OseiNorth$12,400$13,100$11,800$36,000$37,300
3Ben FischerSouth$9,800$10,250$12,100$30,000$32,150
4Lina ChenEast$15,200$14,800$16,900$45,000$46,900
5Diego AlvarezWest$8,700$9,100$8,400$28,000$26,200
6Eva NovakNorth$11,200$12,600$13,900$36,000$37,700
7Farid HaddadSouth$13,300$12,900$14,100$39,000$40,300
8Grace KimEast$10,100$9,600$10,800$33,000$30,500
9Hugo MartinWest$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