Confident Cells

Percentages in Excel: of a total, change and increase

20 November 2026 · 2 min read

In a spreadsheet, a percentage is a part divided by the whole, shown with the % format. 30 out of 120 is 30 ÷ 120 = 0.25, which the % format shows as 25%. There's no need to multiply by 100.

Percentage of a total

A team sold 120 items. Grace sold 30 of them. What share is that?

30 ÷ 120 = 0.25. As a percentage, 25%.

=B2/B6

Then click the % button (or press Ctrl+Shift+5) to show 0.25 as 25%. If you'll copy the formula down, lock the total with $: =B2/$B$6.

ABC
1NameSoldShare
2Grace3025%
3Tom4235%
4Priya1815%
5Marek3025%
6Total120100%
C2 holds =B2/$B$6, copied down. The shares add up to 100%.

Percentage change

Sales went from 80 last month to 92 this month. By what percentage did they go up?

  1. Work out the change: 92 − 80 = 12.
  2. Divide by where you started: 12 ÷ 80 = 0.15.
  3. That's 15%.
=(C2-B2)/B2

The brackets matter: without them, Excel divides first and works out C2 − (B2 ÷ B2). A fall gives a negative answer: from 80 down to 68 is −12 ÷ 80 = −15%.

ABCD
1ItemLast monthThis monthChange
2Paper809215%
3Pens8068-15%
4Folders506020%
D2 holds =(C2-B2)/B2, copied down.

Adding or taking off a percentage

A price of £40 goes up by 5%. 5% of £40 is £2, so the new price is £42. As a formula, multiply by 1 plus the percentage:

=B2*(1+C2)

With 5% in C2, that's £40 × 1.05 = £42. For a 20% discount, use =B2*(1-C2): £40 × 0.8 = £32.

To add VAT at 20%, the same idea gives =B2*1.2. To take VAT off a price that includes it, divide instead: £60 ÷ 1.2 = £50. (Taking 20% off £60 gives £48, which is wrong.)

Common mistakes

2500% instead of 25%

You multiplied by 100 and used the % format, so it was multiplied twice. Leave out the ×100.

Dividing by the new number

Percentage change is always divided by where you started. From 80 to 92 is 12 ÷ 80 = 15%, not 12 ÷ 92 = 13%.

Percentages that don't add up to 100%

Each one is rounded for display. Three equal shares each show as 33.3%, which looks like 99.9% in total, but the real values still add up to 100%. Use ROUND only if you need the rounded figures themselves.

#DIV/0!

The starting value or total is 0. Wrap the formula in IFERROR to show something else.

Try it now

Your turn

In D2, work out the percentage change in sales from last month to this month. Column D is already set to show percentages. Your formula will be copied down to D7.

ABCD
1ItemLast monthThis monthChange
2Paper8092
3Pens8068
4Folders5060
5Staples4030
6Envelopes125150
7Labels6472