Finding a percentage in Excel is one of those tasks that sounds simple — until you stare at the spreadsheet and freeze. Do you multiply? Divide? Format the cell? Use a function? The honest answer: it depends on what you mean by "find." Are you calculating what percentage one number is of another? Converting a decimal into a percent? Working out percentage change between two months of sales? Each scenario uses a slightly different approach, and mixing them up is the fastest way to end up with a column full of 4500% instead of 45%.
Here's the thing nobody tells you when you start out. Excel doesn't have a single PERCENT() function. It has formatting, basic arithmetic, and a quiet rule that says: divide first, then format. Once you understand that rule, every percentage problem in the program — from sales tax to grade calculations to year-over-year growth — collapses into the same two steps. Calculate the ratio. Apply the percent format. That's it. The rest is just knowing which cells to point at.
This guide walks through every common percentage scenario you'll meet in a real spreadsheet. We'll cover the basic formula, percentage of a total, percentage increase and decrease, percentage change between two values, how to handle the dreaded #DIV/0! error, and the difference between formatting a cell as percent versus multiplying by 100. By the end you'll be the person other people in the office message when their sales report shows 0.42 instead of 42%.
A percentage is just a ratio expressed out of 100. If you scored 18 out of 20 on a quiz, your ratio is 18/20 = 0.9, and your percentage is 90%. Notice what happened: 0.9 and 90% are the same number. Excel treats them identically under the hood. The only difference is how the cell displays the value. Format the cell as a number and you see 0.9. Format it as a percentage and you see 90%.
This is the single most important concept to grasp. When you type =18/20 into a cell and press Enter, Excel stores 0.9. If you then click Home → Number Format → Percentage (or hit Ctrl+Shift+%), the same 0.9 displays as 90%. You did not multiply by 100. Excel did that visually, behind the scenes, while keeping the real value at 0.9 so future math stays accurate.
Why does this matter? Because beginners often type =(18/20)*100, get 90, and then apply percent formatting on top — turning 90 into 9000%. The fix is to pick one approach. Either calculate the ratio and apply percent format, or calculate the ratio times 100 and label the column header "Percent" without applying the format. Most Excel power users do the first because it keeps the underlying values clean for further calculations.
Excel's percent format multiplies the displayed value by 100 automatically. Never multiply by 100 in the formula AND apply percent formatting — you'll get a number 100 times too large. Pick one approach: either format the ratio as percent, or multiply by 100 and use plain number format. Mixing the two is the single most common mistake spreadsheet users make when working with percentages, and the visual gives it away immediately when you see values like 2500% where you expected 25%.
Say you have total sales in cell B2 (5000) and the sales for one product in cell A2 (1250). To find what percentage that product represents:
Click on cell C2 and type =A2/B2. Press Enter. You'll see 0.25. Now with C2 still selected, press Ctrl+Shift+%. Excel transforms the display to 25%. Done. The underlying value is still 0.25, which means if you reference C2 in another formula, Excel still treats it as a quarter.
The same pattern works for any "what percent is X of Y" question. Grades: marks earned divided by marks possible. Budgets: amount spent divided by amount allocated. Attendance: days present divided by total days. Always put the smaller piece on top and the total on the bottom, then format the result as percent. If you accidentally invert the ratio, you'll get values over 100% — a quick visual signal that you reversed the operands.
One value divided by a grand total. Example: =B2/B10 where B10 holds the column sum. Use absolute reference (B$10) if dragging the formula down a list of rows so every cell still references the same total.
New value minus old value, divided by old value. Formula: =(B2-A2)/A2. Positive result means growth, negative means decline. Format the cell as percent and you're done — no extra multiplication needed.
Need 15% of 200? Type =200*15%. Excel reads 15% as 0.15 internally. Same approach works for sales tax, discounts, tips. The % symbol is a real operator, not just a display format.
If a price after 20% tax is $120 and you want the pre-tax amount: =120/(1+20%). The +20% adds 0.20 to 1, giving 1.20, the multiplier you originally applied to get from net to gross.
This is the most common percentage task in real spreadsheets. You have a list of sales figures in column B, rows 2 through 9, and B10 holds the SUM of that column. You want column C to show each row's share of the total.
In C2 type =B2/$B$10. The dollar signs lock the reference to B10 so when you drag the formula down to C9, every row still divides by the same grand total. Without those dollar signs, C3 would try to divide by B11 (empty), C4 by B12, and so on — giving you a column of errors and bizarre numbers.
After dragging, select C2:C9 and apply percent format. The whole column now reads as percentages that should sum to 100%. If they don't add up exactly to 100%, you're likely seeing rounding — Excel displays whole percents but stores decimals. To see more precision, click "Increase Decimal" on the Home tab until you can verify the total. For presentation, one decimal place (24.7%) usually strikes the right balance between accuracy and readability.
One gotcha worth flagging. If B10 contains a formula like =SUM(B2:B9), and you later insert a new row above row 10, the SUM formula will adapt — but your $B$10 reference in column C will not necessarily follow. Always double-check the total reference after structural edits, or use a named range like "GrandTotal" to bulletproof the formulas.
What is 25 out of 200? Formula: =25/200, format as percent → 12.5%. The cell stores 0.125 but displays as 12.5% after pressing Ctrl+Shift+%. This is the foundation of every percentage operation in Excel — divide first, format second.
Sales went from $4,000 to $5,500. Formula: =(5500-4000)/4000, format as percent → 37.5%. The numerator is the change, the denominator is the original value. Always divide by the older number, not the newer one — that's the single most common mistake.
What is 30% of $850? Formula: =850*30% or =850*0.3. Result: 255. The percent symbol works as a true operator; Excel converts 30% to 0.3 automatically. Useful for tips, taxes, commissions, and discounts where you start from the base.
$96 includes 20% VAT — what's the net price? Formula: =96/(1+20%) → 80. The trick is the (1+rate) divisor, which undoes the original markup. For a discount, use (1-rate) instead to back out the pre-discount price.
Percentage change measures how much a value grew or shrank relative to its starting point. The formula is universal: (new − old) ÷ old. In Excel that becomes =(B2-A2)/A2 if A2 holds the original value and B2 the new one.
Run a quick example. Last month's revenue was $20,000 (A2). This month it's $24,000 (B2). In C2 type =(B2-A2)/A2. Result: 0.2. Apply percent format. Result: 20%. Revenue grew 20% month over month. If this month had been $16,000 instead, the formula would return -0.2, displayed as -20%, signaling a 20% decline.
A clean variant some people prefer is =B2/A2-1. Mathematically identical, fewer parentheses, often faster to type. Both return the same decimal. Use whichever you find more readable. The important thing is to always divide by the old value. Dividing by the new value is a classic mistake that produces a percentage that looks plausible but answers the wrong question.
What if A2 is zero? The formula returns the #DIV/0! error because dividing by zero is undefined. To handle this gracefully, wrap the formula in IFERROR: =IFERROR((B2-A2)/A2, "N/A"). Now empty or zero starting values show "N/A" instead of an ugly error. Some teams prefer to show 100% or a dash; pick a convention and apply it consistently across the workbook.
Sometimes you don't want to find a percentage — you want to apply one. Raise prices by 8%. Cut a budget by 12%. Add 15% tip to a bill. The formula pattern is the same in all cases: original × (1 ± rate).
To increase $200 by 8%, type =200*(1+8%). Excel reads 8% as 0.08, adds it to 1 to get 1.08, then multiplies by 200 → $216. To decrease the same $200 by 8%, use =200*(1-8%) → $184. The (1+rate) and (1-rate) construction is more compact than the alternative =200+200*8% or =200-200*8%, and it scales naturally when you're dragging the formula across hundreds of rows.
Combining multiple percentages? Be careful. Increasing $100 by 10% then decreasing by 10% does not return $100. The first step gives $110, the second gives $99. Each percentage operates on a different base. This is why retailers can advertise "20% off then another 20% off!" and net less than a flat 40% discount. The order of operations and the base value matter, and Excel will faithfully compute whatever you ask — wrong assumptions included.
The keyboard shortcut Ctrl+Shift+% (Cmd+Shift+% on Mac) applies the default percentage format to whatever cells you have selected. It works on a single cell, a range, an entire column, or a non-contiguous selection held together with Ctrl-click. The default shows zero decimal places (50%, not 50.0%), so for more precision click the "Increase Decimal" button on the Home tab.
For more control, open the Format Cells dialog with Ctrl+1. The Number tab includes a Percentage category where you can specify decimal places, sample preview, and apply the change. This is the right place to set up percentage columns in templates because the formatting saves with the workbook and applies to any new values typed into those cells.
Worth knowing: if you type a value into a cell that's already formatted as percentage, Excel interprets your input differently depending on the magnitude. Type 0.25 and it shows 25%. Type 25 and it shows 2500%. The cutoff sits at 1 — values under 1 are treated as the decimal form, values 1 and above as already-percent. This is a frequent source of confusion. The cleanest habit is to format the cell as percent after entering the decimal value, not before.
The same logic applies when you paste data from another source. If you copy a column of decimal ratios from a different file and paste into a percent-formatted column, the values display correctly. If you paste raw whole numbers like 25, 47, 83 into the same column, they balloon to 2500%, 4700%, 8300%. The fix is to format the destination as percent after the paste, or use Paste Special → Values and then format the column. Spotting this early saves time chasing phantom data quality issues later.
The classic blunder is the 100x multiplication. You type =A2/B2*100 to get a "real" percent, then someone applies percent formatting, and suddenly the column reads 2500% instead of 25%. The fix: remove the *100 from the formula, leave the format as percent. Or remove the format and keep the *100. Never both.
Mistake number two is dividing by the wrong base in percentage change. To find growth from $80 to $100, the answer is (100-80)/80 = 25%, not (100-80)/100 = 20%. The denominator is always the starting value because percentages express relative change against the original. Mixing this up in a quarterly report can turn a 25% gain into a 20% gain on a board slide — a small error that becomes a credibility problem.
Third pitfall: forgetting to lock the total cell reference when dragging. =B2/B10 dragged down to C9 becomes =B9/B17 because both references shift. Press F4 on the second reference to make it $B$10, and the column populates correctly. Spotting this is easy — if percentages decrease randomly down the list and the last few rows show #DIV/0!, you missed the lock.
Final one: copy-pasting percent-formatted cells into a cell formatted as number, or vice versa. The underlying value transfers, but the display flips. Always use Paste Special → Values if you want to break the connection, or Paste Special → Formats if you want to preserve formatting. Or just retype if the dataset is small. Speed isn't worth introducing silent errors that you'll catch three days later when your boss asks why the report doesn't tie out.
Finding percentages in Excel comes down to two reliable habits. First, calculate the ratio: part divided by whole, or change divided by original. Second, apply percent format with Ctrl+Shift+%. That's the whole game. Every percentage scenario — sales of total, year-over-year growth, sales tax, discounts, exam scores — reduces to those two steps once you know which numbers go on top and which go on bottom.
The traps to dodge are predictable. Don't multiply by 100 and apply percent format together. Don't divide by the new value when calculating change. Don't forget to lock references with F4 when dragging formulas down a column. Don't share a report with #DIV/0! errors visible. Wrap every percentage formula in IFERROR if there's any chance the denominator could be zero or blank.
If you've made it this far, you now know more about percentage formulas in Excel than most office workers who use the program daily. The next step is muscle memory — opening a fresh sheet, typing the formulas without looking them up, and trusting that the format will handle the visual conversion. Pair that with the related skills in our Excel cheat sheet, the SUM formula guide, and the broader percentage calculation tutorial, and you've got a percentage toolkit that handles whatever a spreadsheet throws at you.
One last word. Percentages on a screen are easy. Percentages explained to a non-spreadsheet person — your manager, a client, a teammate from another department — are harder. The trick there is to always state the base. "Revenue grew 30%" is incomplete. "Revenue grew 30% versus the same quarter last year" is a real statistic. Excel handles the math; you handle the context. Get both right and your reports do the heavy lifting for you.
A handy field test before sending a report: select the column, look at the status bar at the bottom of Excel. It shows Average, Count, and Sum of the selected cells. For a percent-of-total column, the Sum should be 100% (or 1.0 if you're viewing as decimal). For a percentage change column, scanning the average tells you the overall trend of the dataset at a glance, no extra formula needed. Small habits like this catch problems before anyone else has to.
And remember — the same formulas work in Google Sheets, LibreOffice Calc, and Apple Numbers. Once you master percentages in Excel, the skill ports anywhere a grid of cells exists.