How To Enter Percentage Formula In Excel

The correct way to enter a percentage formula in Excel is to use =part/total and apply Percent Style formatting — never multiply by 100.

Most people reach for =45/60*100 on their first try, get 75, and stare at the cell wondering what went wrong. Nothing did—the *100 is the problem. Excel’s built-in Percent Style button does that conversion automatically, and using both doubles the result. The fix is a two-step pattern that works the same in Excel 2016, Excel 2021, and Microsoft 365: divide, then format. Here is exactly how it works, along with the three formula types you will use most often.

How To Enter A Percentage In Excel: Two Steps, No Guesswork

The foundational formula is simple division. It works for any scenario where you need one number as a percentage of another—test scores, sales targets, budget spend, you name it.

Click a blank cell where you want the percentage to appear.
Type =part/total using real numbers or cell references—for example, =42/50 or =B2/C2.
Press Enter (Windows) or Return (Mac). Excel shows a decimal, such as 0.84.
Keep the cell selected. On the Home tab, find the Number group and click the Percent Style button (%)—or press Ctrl+Shift+% (Windows) / ⌘+Shift+% (Mac).

The decimal 0.84 changes to 84% instantly. You do not multiply by 100 anywhere in the process.

This method is version-stable. The Percent Style button has lived in the same spot on the Home tab since Excel 2007, and the keyboard shortcut works across every modern version including Excel for the web.

Why Does Multiplying By 100 Break The Result?

The confusion comes from how percentages work outside Excel. In everyday math, you turn a fraction into a percentage by multiplying by 100. Excel’s Percent Style does that exact multiplication internally. When you write =42/50*100 and then apply Percent Style, Excel takes the 84 result and treats it as 84.00, converting it to 8400%. The formula works correctly only if you skip the *100 and let the formatting handle it.

The same logic applies to cell references. If your formula is =B2/C2 and B2 holds 42 while C2 holds 50, the result is 0.84. Format as Percentage and it reads 84%. Add *100 and you get 8400% every time.

How Do You Calculate A Percentage Of A Number Directly?

Sometimes you already have the percentage and need to find the portion of a total—say, 20% of 50,000. Excel lets you type the percent sign directly into the formula.

Type =50000*20% in a blank cell.
Excel interprets 20% as 0.20 automatically and returns 10000.

This works with cell references too. If A1 holds the total and B1 holds the percentage (typed as 20%), the formula =A1*B1 gives you the correct portion. The percentage sign is not cosmetic—Excel stores 20% internally as 0.20, so the math is sound regardless of how the cell is formatted.

The Percentage Change Formula

For comparing an old value to a new value—month-over-month revenue, year-over-year growth, or weight change—the formula is:

Type =(new_value - old_value) / old_value, such as =(C2-B2)/B2 where C2 is the new figure and B2 is the baseline.
Press Enter, then format the result as a percentage using Ctrl+Shift+%.

A positive result means an increase; a negative result (shown as -5%) means a decrease. The parentheses are critical: =C2-B2/B2 divides B2 by B2 first and then subtracts, giving you a wrong answer every time. Stick with =(C2-B2)/B2.

Three Formula Mistakes And Their Fixes

These are the errors that send most people back to a search engine. The table below covers each one with the correction and the reason it matters.

Mistake	What You See	Fix
Adding `*100` before Percent Style formatting	`8400%` instead of `84%`	Remove the `*100` and let Percent Style do the conversion
Forgetting to format the cell as Percentage	`0.84` instead of `84%`	Select the cell and click Percent Style or press Ctrl+Shift+%
Omitting parentheses in the change formula	Wrong percent change value	Use `=(new-old)/old` with both sets of parentheses
Typing the percentage as a plain decimal without formatting	`0.15` shows as `15%` only after Percent Style is applied	Type `15%` directly, or type `0.15` and format afterward
Using a text-formatted number in a formula	`#VALUE!` error	Convert the text to a number using `=VALUE()` or re-enter it as a numeric value
Typing the percentage into the formula as `20` instead of `20%` or `0.20`	Result is 20 times larger than expected	Use `20%` or `0.20` — Excel treats bare `20` as 20, not 20%
Applying Percent Style to a cell that already contains a whole-number percentage	Value multiplies by 100 again	Check the raw cell value before formatting; if it’s already `84`, divide by 100 first or re-enter as `=42/50`

Microsoft’s official percentage documentation covers the same =42/50 pattern and confirms that Percent Style handles the conversion without manual multiplication.

Which Excel Versions Support These Formulas?

Every formula in this article works on Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016. The Percent Style button and the Ctrl+Shift+% shortcut are identical across all of them. Excel for the web includes the same button on the Home tab, though the keyboard shortcut may not work in all browsers—use the toolbar button instead. Mac users press ⌘+Shift+% with the same result.

Older versions (Excel 2007 and 2010) use the same formula logic and the same Percent Style location. The only real difference is the visual design of the ribbon, which is narrower in those releases, but the button label (%) has not changed.

Quick Reference: Three Essential Percentage Formulas

What You Want	Formula Structure	Example
One number as a percentage of another	`=part/total`	`=42/50` → `84%`
Percentage of a given number	`=number * percentage%`	`=50000*20%` → `10000`
Percent change between two values	`=(new-old)/old`	`=(120-100)/100` → `20%`

The pattern is consistent across all three: divide to find the proportion, then apply Percent Style. Once you know which of the three formulas matches your data, you can enter it in under ten seconds and trust the result without rechecking the math.

References & Sources

Microsoft Support. “Calculate percentages.” Official steps showing the =42/50 formula with Percent Style formatting.