How to Calculate Percentages in Excel
Introduction
You divide one number by another and get 0.25. Is that 25%? Do you multiply by 100? Or just format the cell? Percentage calculations in Excel confuse people because the math and the formatting overlap. Get them out of sync and you end up with "2500%" in a cell that should say "25%." Three formulas handle nearly every percentage calculation, and one formatting rule keeps them all from going wrong.
The Dataset
Here's a quarterly sales report for a small electronics distributor:
| A | B | C | |
|---|---|---|---|
| 3 | Product | Q1 Sales | Q2 Sales |
| 4 | Laptops | 50,000 | 60,000 |
| 5 | Monitors | 25,000 | 20,000 |
| 6 | Keyboards | 10,000 | 15,000 |
| 7 | Headsets | 15,000 | 18,000 |
| 8 | Total | 100,000 | 113,000 |
The distributor needs to know each product's share of total sales, how much each product grew or declined, and what a 10% discount on Q2 prices would look like.
Percentage of Total
To find what share each product represents, divide the product's sales by the total:
=B4/B8
This returns 0.5 for Laptops (50,000 / 100,000). Format the cell as a percentage and it displays 50%.
| Product | Q1 Sales | % of Total |
|---|---|---|
| Laptops | 50,000 | 50% |
| Monitors | 25,000 | 25% |
| Keyboards | 10,000 | 10% |
| Headsets | 15,000 | 15% |
The formula is always the same: part divided by whole. Lock the total row with an absolute reference so you can copy the formula down without the denominator shifting:
=B4/$B$8
The dollar signs on $B$8 keep the reference fixed on the total row as you copy down to B5, B6, and B7. Without them, the denominator shifts down one row per cell and gives wrong results.
Key takeaway: Percentage of total is part / whole. Let Excel's percentage format handle the conversion from decimal to percent. Don't multiply by 100 yourself.
Percentage Change
To measure growth or decline from one period to another, subtract the old value from the new and divide by the old:
=(C4-B4)/B4
For Laptops, this is (60,000 - 50,000) / 50,000 = 0.2, which displays as 20% when formatted as a percentage. Sales grew by a fifth.
| Product | Q1 | Q2 | % Change |
|---|---|---|---|
| Laptops | 50,000 | 60,000 | 20% |
| Monitors | 25,000 | 20,000 | -20% |
| Keyboards | 10,000 | 15,000 | 50% |
| Headsets | 15,000 | 18,000 | 20% |
Monitors dropped 20% while Keyboards jumped 50%. The negative sign appears automatically when the new value is smaller than the old. No special handling needed.
Notice that Laptops and Headsets both grew at the same 20% rate, but Laptops added $10,000 in actual revenue while Headsets added $3,000. Percentage change shows the rate of growth, not the dollar impact. Both numbers matter for different decisions.
The formula pattern is always: (new - old) / old.
Markup and Discount
To add a percentage to a value (markup), multiply by 1 plus the rate. To subtract a percentage (discount), multiply by 1 minus the rate.
Adding a 30% markup to a cost of $80:
=80 * 1.3
The result is 104. The 1 keeps the original value, and the 0.3 adds 30% on top.
Applying a 10% discount to Q2 sales:
=C4 * 0.9
For Laptops (60,000), this returns 54,000. The 0.9 keeps 90% of the value, which is the same as removing 10%.
| Product | Q2 Sales | After 10% Discount |
|---|---|---|
| Laptops | 60,000 | 54,000 |
| Monitors | 20,000 | 18,000 |
| Keyboards | 15,000 | 13,500 |
| Headsets | 18,000 | 16,200 |
If the discount rate lives in a cell (say F1 contains 0.10), the formula becomes:
=C4 * (1 - $F$1)
Change F1 to 0.15 and every discounted price updates to reflect a 15% cut. This is cleaner than hard-coding the rate into each formula.
The Formatting Rule
Excel stores percentages as decimals internally. When you format a cell as "Percentage," Excel multiplies the stored value by 100 for display. That means:
| You type | Cell stores | Formatted as % shows |
|---|---|---|
| 0.25 | 0.25 | 25% |
| 25 | 25 | 2500% |
| =50000/100000 | 0.5 | 50% |
The rule: never multiply by 100 if you're also formatting as percentage. Pick one or the other.
If your formula already returns a decimal (like =B4/B8 returning 0.5), just format the cell as percentage. Excel handles the display.
If you're entering values manually and want to type "25" to mean 25%, format the cell as percentage first, then type 25. Excel converts your input to 0.25 internally and displays 25%.
The most common mistake is writing =B4/B8*100 and then also formatting as percentage. The formula returns 50, the formatting multiplies by 100 again, and the cell shows 5000%. If you see a number that's 100 times too large, this is almost always why.
Conclusion
Three formulas cover most percentage work in Excel: part / whole for shares, (new - old) / old for change, and value * (1 +/- rate) for markup and discount. Let the percentage format handle the display and never multiply by 100 on top of it.
For locking cell references when copying percentage formulas, see our guide on absolute and relative references. For conditional totals that feed percentage calculations, check out our guide on SUMIF and COUNTIF.
Level up your Excel skills
Bite-sized lessons, drills, and daily challenges to build real spreadsheet skills.