How Do I Calculate Percentage in Excel? | Stop Formula Mistakes

Percentages feel simple until Excel shows 0.2 when you wanted 20%, or 2000% when you wanted 20.00%. That’s where most people get tripped up. The math is easy. The cell setup is what causes the mess.

If you want one clean rule, use this: divide one value by another, then apply the Percentage format. That turns a decimal into the familiar percent view. Once that clicks, you can work out test scores, discounts, growth, markup, tax, and completion rates without second-guessing every formula.

How Do I Calculate Percentage In Excel? For Totals, Change, And Markup

Excel treats percentages as decimals behind the scenes. So 25% is stored as 0.25. That single fact explains most weird-looking results.

Start with the part-over-total pattern. If cell B2 holds 45 and C2 holds 60, type =B2/C2. Excel returns 0.75. Apply Percentage format and it displays 75%.

That same pattern works in loads of cases:

• Correct answers out of total questions
• Sales made out of target sales
• Completed tasks out of all tasks
• Budget spent out of total budget

If you want Microsoft’s own walkthrough, their page on calculate percentages shows the same core patterns used in Excel.

Start With The Plain Pattern

Use this structure any time one number is part of another:

=part/total

That means:

• =25/100 gives 25%
• =18/24 gives 75%
• =B2/C2 gives the share of C2 taken by B2

Don’t multiply by 100 unless you plan to leave the cell in General format. In normal Excel work, it’s cleaner to keep the formula as a division and let the percentage format do the display work.

Know When To Format First

There are two common ways people enter percentage values in a cell:

• Type 20% and Excel stores 0.2
• Type 0.2 and format it as Percentage so it shows 20%

What causes trouble is typing 20 into a cell that is already set to Percentage. Excel reads that as 2000%. If a result looks wildly off, check the stored value before you blame the formula.

Percentage Formulas You’ll Use Again And Again

Once you know the base rule, the rest is just choosing the right version for the job.

Find What Percent One Number Is Of Another

Use this when you want a share of a whole.

=B2/C2

Say B2 is 80 and C2 is 200. The result is 40% after formatting.

Find The Percentage Change Between Two Numbers

Use this when comparing an old value with a new one.

=(New-Old)/Old

In cells, that might be =(C2-B2)/B2. If B2 is 50 and C2 is 65, the result is 30%.

Add A Percentage To A Number

Use this for markup, tax, or pay rises.

=B2*(1+C2)

If B2 is 100 and C2 is 15%, the result is 115.

Subtract A Percentage From A Number

Use this for discounts or cuts.

=B2*(1-C2)

If B2 is 100 and C2 is 15%, the result is 85.

Find Only The Percentage Amount

Use this when you want the tax amount, commission amount, or discount amount by itself.

=B2*C2

If B2 is 240 and C2 is 10%, the result is 24.

Task	Formula	What It Returns
Part of total	=B2/C2	Share of the whole
Test score	=Correct/Total	Score as a percent
Budget used	=Spent/Budget	Used portion
Growth rate	=(New-Old)/Old	Percent increase or drop
Add markup	=Price*(1+Rate)	New higher amount
Apply discount	=Price*(1-Rate)	New lower amount
Tax amount only	=Amount*Rate	Tax value
Completion rate	=Done/All	Progress as a percent

Formatting The Result So Excel Shows The Right Thing

A formula can be right and still look wrong on screen. That’s a display issue, not a math issue.

After entering your formula, select the result cell and apply Percentage format from the Home tab. You can also press Ctrl+Shift+% on Windows. Microsoft’s note on format numbers as percentages in Excel also shows how decimal places affect the result you see.

Use one or two decimal places when precision matters. A dashboard might look cleaner with 12%. A pricing sheet may need 12.50%.

General Format Vs Percentage Format

This is the difference that catches people out:

• =1/4 in General format shows 0.25
• =1/4 in Percentage format shows 25%

The stored number is the same. Only the display changes.

When Manual Entry Goes Wrong

Say you type 15 into a Percentage-formatted cell. Excel shows 1500%. That’s not a bug. Excel assumes 15 means fifteen whole units, then converts that to percent format.

If you want fifteen percent, enter 15% or 0.15. That one habit saves a pile of cleanup later.

Common Jobs Where Percentage Math In Excel Pays Off

Percentages show up all over a worksheet, often under different names. Once you spot the pattern, the formulas stop feeling like separate tasks.

Sales And Revenue Sheets

Use percentages for margin rates, growth rates, discount rates, and target progress. If monthly revenue rises from 12,000 to 15,000, use =(15000-12000)/12000. Format the result as a percentage and you have a 25% rise.

Marks And Grading

For a student score, divide correct answers by total questions. If a learner gets 42 out of 50, type =42/50. The result is 84% after formatting.

Budgets And Spending

Budget sheets often need two views: how much has been spent, and how much is left. If you spent 630 out of 900, use =630/900 for the used rate. Then use =1-(630/900) for the remaining rate if you want the percent left.

Price Changes

For markup, use =Base*(1+Rate). For discounts, use =Base*(1-Rate). For a cleaner feel with mixed formulas, stick with cell references and keep your rate in one place so you can copy the formula down a full column.

If You See This	Likely Cause	Fix
0.2 instead of 20%	Cell is still in General format	Apply Percentage format
2000% instead of 20%	Typed 20 into a percent cell	Enter 20% or 0.2
#DIV/0!	Total cell is blank or zero	Check the denominator first
Wrong change rate	Old and new values swapped	Use =(New-Old)/Old
Copied formula breaks	Reference shifts	Use $ for fixed cells where needed
Too many decimals	Display is cluttered	Reduce decimal places

Small Excel Habits That Make Percentage Work Easier

Good percentage formulas don’t just come from math. They come from tidy sheet habits.

• Store rate values in their own cells instead of typing them into each formula.
• Use clear headers such as Old Value, New Value, Rate, and Result.
• Copy formulas down columns instead of retyping them row by row.
• Lock fixed cells with absolute references like $C$1 when one rate applies to many rows.

If your sheet starts getting messy, Microsoft’s overview of formulas in Excel is a handy refresher on cell references, operators, and formula structure.

What To Check Before You Trust The Result

Run this short sanity check each time:

1. Is the formula dividing the right value by the right total?
2. Is the denominator nonzero?
3. Is the result cell formatted as Percentage when needed?
4. Did you type 15% instead of 15 in a percentage cell?
5. For change rate, did you divide by the old value, not the new one?

If those five points check out, your percentage is usually solid. Most Excel percentage mistakes come from formatting, flipped cell references, or using the wrong base number. Once you catch those three, percentage work gets a lot less annoying.