How to calculate a percentage in Excel
To calculate a percentage in Excel, divide the part by the total, as in =B2/C2, and then format the cell as a percentage with Ctrl+Shift+%. Excel stores 25% as 0.25, so you do not multiply by 100. This guide covers the three formulas you will use most often: the share of a total, the percent change, and an amount increased by a percent.
1. What percent is one number of another
Divide the part by the whole. If 50 of 200 orders arrived late, the share is 50 / 200 = 0.25. Format the result cell as a percentage and it shows 25%. Select the cell and press Ctrl+Shift+%, or click the % button on the Home tab.
Example: Late orders as a share of all orders
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Late | Total | Share |
| 2 | Orders | 50 | 200 | 0.25 |
50 divided by 200 is 0.25. With the percent format the cell shows 25%.
2. Percent of a column total
To show every row as a share of the column total, divide each value by the total cell and lock the total with dollar signs: =B2/$B$8. The lock keeps the denominator in place while you fill the formula down. Then format the whole column as a percentage. The shares should add up to 100%.
3. Percent change between two numbers
To find how much a number grew or shrank, subtract the old value from the new one and divide by the old one: (new - old) / old. A positive result is an increase and a negative result is a decrease. The brackets matter, because division is done before subtraction.
Example: Price rose from 80 to 100
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Old | New | Change |
| 2 | Price | 80 | 100 | 0.25 |
The increase is 20, and 20 divided by the old price 80 is 0.25, a 25% rise.
4. Add or subtract a percent
To raise an amount by a percent, multiply it by 1 plus the percent. To lower it, multiply by 1 minus the percent. Type the percent in its own cell so you can change it later. Wrap the result in ROUND when you want a price with two decimals.
Example: A 200 price plus 15%
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Price | Raise | New price | |
| 2 | 200 | 0.15 | 230 |
200 times 1.15 is 230. ROUND keeps the result at two decimals.
Common mistakes
Multiplying by 100 and then using the percent format. The cell then shows 2500% instead of 25%.
Fix: Do one or the other: format as a percentage, or multiply by 100 and keep the General format.
Forgetting the brackets in a change formula. =C2-B2/B2 divides first and gives the wrong answer.
Fix: Write =(C2-B2)/B2.
Typing 15 instead of 15%. A raise of 15 means 1500%.
Fix: Type 15% (with the sign) or enter 0.15 and format the cell as a percentage.
Frequently asked questions
How do I show a number as a percentage?
Select the cells and press Ctrl+Shift+%. Excel multiplies the value by 100 only for display, and the cell still holds the original number.
How do I calculate a percentage of a number, such as 20% of 350?
Multiply: =350*20%. Excel reads 20% as 0.2, so the result is 70.
Why does my percent change show #DIV/0!?
The old value is zero or blank. Wrap the formula in IFERROR to show a dash instead.
Related functions
- ROUNDROUND rounds a number to a set number of digits; ROUNDUP and ROUNDDOWN always round away from or toward zero.
- SUMSUM adds up numbers, cells and whole ranges in one formula.
- AVERAGEAVERAGE returns the arithmetic mean of numbers or a range, skipping text and empty cells.
- IFERRORIFERROR returns a value you choose when a formula produces an error such as #N/A or #DIV/0!, and the normal result otherwise.
More on percentages
The guide covers the share of a total, the percent change and a price plus a percent. This piece adds how Excel stores percentages, how to handle a negative change, and how to round percentages that must add up to 100.
How Excel stores a percentage
A percentage in Excel is an ordinary number with a display format. The cell shows 25%, but it holds 0.25. This is why =A2*B2 works when B2 shows 20%: Excel multiplies by 0.2. It is also why typing 25 in a cell formatted as a percentage gives 25%, while typing 25 in a General cell and applying the format afterwards gives 2500%.
Negative and awkward changes
A drop from 100 to 80 gives =(80-100)/100, which is -20%. That is correct. The trouble starts when the old value is negative or zero. A change from a negative number is not meaningful, and a change from zero gives #DIV/0!. Decide in advance what the cell should say, then write it explicitly.
=IF(B2<=0,"n/a",(C2-B2)/B2)Shares that must add up to 100%
When you round each share to a whole percent, the total can show 99% or 101%. The values are right, but the display is rounded. If the total must read 100%, round all but the last share with ROUND, and calculate the last one as 1 minus the sum of the others.
Practice with [the number formats lesson](/learn/number-formats) and [rounding](/learn/rounding). To keep a total fixed while you fill a formula down, review [cell references](/guides/cell-references).