How to Calculate Percentages in Excel (Step-by-Step)

Why did your formula return 0.25 when you needed 25%? Or why did Excel suddenly show 1000% the moment you clicked the percent button? These aren't random bugs. They're the two most predictable stumbles in percentage work, and they both have clean fixes once you understand what's actually happening.

This guide covers three things: calculating a percentage of a total, calculating percentage change between two numbers, and avoiding the formatting mistakes that silently wreck results. Percentage formulas were in nearly every dashboard I built during my years as a financial analyst, and most of the frustration comes from skipping one concept I'll explain before you write a single formula.

One Formatting Trap to Understand Before You Write a Single Percentage Formula in Excel

A percentage is a division result, formatted. That's it. When you calculate a percentage in Excel, you're dividing one number by another and telling Excel to display the result as a percentage. The formula and the formatting are two separate steps, and confusing them is where most people go wrong.

If you type 10 into a cell and then apply Percent Style, Excel multiplies that value by 100 and shows 1000%. It's not broken — it's doing exactly what you asked. Excel stores percentages as decimals (25% is stored as 0.25), so applying Percent Style to a whole number produces 1000%. Fix it by entering the number as a decimal first (0.10), or by applying the percent format to an empty cell before typing your value.

If you're just getting started with Microsoft Excel overall, the Excel for Beginners starter guide covers cell formatting and number types in more depth — worth a read before going further.

---

Step 1: Calculate a Percentage of a Total Using a Divide Formula and an Absolute Cell Reference

Once you've got the formatting concept down, building the actual percentage formula is just division. To find what percentage one value is of a total, divide the part by the whole: =B2/C2. You're asking Excel: what fraction of the total does this number represent?

Say Sarah Chen's Q3 sales are in B2 and total team sales are in C2. The formula =B2/C2 gives you Sarah's share. Format that cell as a percentage and you're done.

Lock Your Denominator With an Absolute Cell Reference Before Copying the Formula Down

The problem shows up when you copy that formula down for Marcus Rivera in row 3, James Okafor in row 4, and so on. By default, Excel shifts every cell reference as you copy — so C2 becomes C3, C4, and so on. Your denominator changes with each row, which means you're no longer dividing by the same total. Your percentages will be wrong, and Excel won't warn you.

The fix is an absolute cell reference. Change your formula to =B2/$C$2. The dollar signs lock the column and row so C2 stays C2 no matter where you copy the formula.

If your totals column uses a SUM function (like =SUM(B2:B10) in C2), anchor that SUM cell the same way. The Excel formula for percentage of total is always: =(part)/($total) — part relative, total locked.

---

Step 2: Calculate Percentage Change in Excel to Show Increase or Decrease Between Two Numbers

With your percentage-of-total formula working, the next calculation you'll likely need is percentage change — how much did a number grow or shrink between two periods?

The percentage change formula is: =(new value − old value) / old value. In cell references: =(B2−A2)/A2. A positive result is an increase; a negative result is a decrease. Format the cell as a percentage and you're reading the change directly.

Build it inside out. First confirm that B2−A2 gives you the right difference, then wrap it: =(B2−A2)/A2. This inside-out approach applies to every compound formula — test the inner piece before adding the outer layer. It catches order-of-operations errors before they compound.

If Sarah's January sales (A2) were $40,000 and her February sales (B2) were $47,000, the formula returns 0.175, which formats to 17.5% increase. The same formula handles a decrease automatically — if B2 is smaller than A2, you get a negative percentage.

Use PERCENTOF in Excel 365 If You're Working With a List Instead of Two Cells

If you're on Microsoft Excel 365, there's a newer function worth knowing: =PERCENTOF(data_subset, data_all). Instead of dividing a single cell by a total, PERCENTOF calculates what percentage one range of values is of a larger range. It's cleaner for list-based analysis — say, what percentage of total sales came from the Western region — without needing a helper SUM formula. For two-cell percentage change (new vs. old), the classic formula is still the better fit. PERCENTOF earns its keep when you're working with filtered lists or dynamic arrays.

---

Common Mistakes When Calculating Percentages in Excel

You've already seen the first one: applying Percent Style to a whole number. Enter your values as decimals or format the cells before typing, not after.

1. Applying Percent Style to a whole number. Enter values as decimals or format empty cells before typing. Formatting after the fact multiplies existing values by 100.
2. Forgetting to lock the denominator. The formula looks right for the first row and breaks silently for every row after. Always anchor your total cell with dollar signs.
3. Using simple percentage change when you need CAGR. Percentage change between two years tells you total growth over the period. CAGR tells you the smoothed yearly rate. A business that grew 60% over four years didn't necessarily grow 15% per year — CAGR accounts for compounding. If you're doing multi-period analysis, Excel's basic statistical functions page covers the formula structure for CAGR and when each approach fits the question you're actually asking.

For anyone building this kind of percentage analysis into a larger inventory or sales workflow, the patterns here map directly to what's covered in data analysis in Excel for retail inventory, particularly the budget-vs-actual variance work where percentage formulas do the heaviest lifting.

---

---

If you take one thing from this article: a percentage is a division result, formatted. Get the division right first, apply the formatting second, and lock your denominators before you copy anything down. Every percentage formula in Excel — no matter how complex it looks — starts from those three things.