How to Calculate Percentages in Excel (5 Easy Formulas + Examples)

Calculating percentages in Excel is one of the most common tasks in office work and also one of the most confusing for beginners.

Whether you’re working out discounts, tracking growth, calculating scores, or measuring progress toward a goal, Excel uses a few simple formulas that cover almost every percentage scenario.

No math degree needed. No complicated jargon. Just clear, practical examples you can use right away.

This tutorial is designed for:

• New to Excel and feeling a bit overwhelmed
• An office worker who needs to create reports with percentages
• A student working on assignments or projects
• A small business owner tracking sales, expenses, or growth
• Anyone who wants to stop second-guessing their percentage calculations

In this guide, you’ll learn 5 easy Excel percentage formulas, exactly when to use each one, and the most common mistakes that cause wrong results.

The Most Important Thing to Know About Percentages in Excel

Here’s the good news: Excel already knows how to do the math. You just need to tell it what numbers to work with.

A percentage is simply one number divided by another, then displayed in a way that’s easy to read. For example:

• 25 out of 100 = 0.25 = 25%
• 1 out of 4 = 0.25 = 25%

Excel handles the division. You just need to format the result so it shows as “25%” instead of “0.25”.

How to Calculate Percentage in Excel (Quick Formula)

Let’s start with the simplest scenario: finding what percentage one number is of another.

The Formula

=Part / Total

That’s it. You’re dividing the smaller number (the part) by the bigger number (the total).

Real-Life Example

Let’s say you’re tracking your reading goal. You’ve read 3 books this month, and your goal is 12 books for the year so far.

Step 1: Click on any empty cell in Excel
Step 2: Type: =3/12
Step 3: Press Enter

You’ll see: 0.25

Step 4: Click the cell again, then click the % button in the toolbar (it’s usually in the “Number” section at the top)

Now you’ll see: 25%

This means you’ve completed 25% of your reading goal. Simple, right?

Using Cell References (The Smarter Way)

Instead of typing numbers directly into the formula, it’s better to reference cells. This way, when your numbers change, the percentage updates automatically.

Let’s say:

• Cell B2 contains purchased Shirts: 40
• Cell C2 contains sold Shirts: 29

In cell D2, type:

=B2/C2

Then format D2 as a percentage. Now whenever you update B2 or C2, D2 automatically recalculates. This is especially helpful when you’re tracking changing data like monthly sales or weekly progress.

Formula #1: Basic Percentage (What Percent Is This of That?)

This is the formula you’ll use most often.

When to Use It

• “What percentage of tasks have I completed?”
• “What’s my test score as a percentage?”
• “What portion of the budget did we spend?”
• “What percentage of customers bought the premium version?”

The Formula

= (Part / Total) 

Example: Test Score
You got 42 questions right out of 50 total questions.

= 42/50 

Result: 84%

Example: Budget Tracking
Your department spent $3,200 out of a $4,000 budget.

=3200/4000

Result: 80% (You’ve used 80% of your budget)

Example: Task Completion
You’ve completed 17 tasks out of 25 tasks on your project list.

=17/25

Result: 68%

For a video walkthrough, watch this YouTube Tutorial on Excel Percentages.

Quick Tip: Excel automatically formats decimals as percentages when you apply the percentage format.

Formula #2: Percentage Increase (How Much Did It Grow?)

Use this when you want to see how much something went up compared to where it started.

When to Use It

• “How much did sales grow this month?”
• “What’s the percentage increase in website visitors?”
• “How much did my savings grow?”
• “What was the salary increase?”

The Formula

(New Value - Old Value) / Old Value

Think of it this way: you’re finding the difference between the new and old values, then seeing what percentage that difference is of the original value.

Example: Sales Growth

• Last month’s sales: $5,000
• This month’s sales: $6,500

=(6500-5000)/5000

Result: 30%

Your sales increased by 30%. This tells you that the growth ($1,500) represents 30% of your starting point ($5,000).

Example: Salary Increase

• Old salary: $45,000 per year
• New salary: $48,600 per year

=(48600-45000)/45000

Result: 8%

You got an 8% raise.

Example: Social Media Growth

• Followers last week: 850
• Followers this week: 1,020

=(1020-850)/850

Result: 20%

Your follower count grew by 20% in one week.

Formula #3: Percentage Decrease (How Much Did It Drop?)

This is almost identical to percentage increase, but you flip the order to calculate a decrease instead.

When to Use It

• “How much did costs decrease?”
• “What discount was applied?”
• “How much did traffic drop?”
• “What’s the percentage reduction in errors?”

The Formula

=(Old Value - New Value) / Old Value

Example: Sale Discount

• Original price: $80
• Sale price: $60

=(80-60)/80

Result: 25%
The item is on sale for 25% off.

Example: Cost Reduction

• Old monthly expense: $2,400.
• New monthly expense: $1,800.

=(2400-1800)/2400

Result: 25%
You’ve reduced your expenses by 25%.

Example: Error Rate Improvement

• Errors last month: 50.
• Errors this month: 35.

=(50-35)/50

Result: 30%
You’ve decreased errors by 30%.

Formula #4: Calculate a Percentage of a Number

Sometimes you need to find a specific percentage of a number like calculating a 15% tip or finding 20% of your budget.

When to Use It

• “What’s 15% of the bill?”
• “How much is 20% off this price?”
• “What’s 10% of my monthly income?”

The Formula:

=Total * Percentage

Important: You need to write the percentage as a decimal or reference a cell formatted as a percentage.

Example: Calculating a Tip
Your restaurant bill is $45, and you want to leave a 15% tip.

=45*0.15

Or if you want to write it with the % sign:

=45*15%

Result: $6.75

Example: Finding a Discount Amount
An item costs $120, and there’s a 30% discount. How much do you save?

=120*0.30

Result: $36 (You save $36)
To find the final price, you’d calculate:

=120-120*0.30

or more simply:

=120*0.70

Result: $84

Example: Budget Allocation
Your monthly income is $4,000, and you want to save 20%.

=4000*0.20

Result: $800

Formula #5: Percentage of Total (Multiple Items)

This formula helps when you have multiple parts and want to know what percentage each part represents of the whole.

When to Use It

• “What percentage of total sales did each product contribute?”
• “What’s each department’s share of the budget?”
• “What percentage of votes did each candidate receive?”

The Formula:

=Individual Value / Sum of All Values

Example: Sales by Product

Product	Sales	Formula	Percentage
Product A	$3,000	=3000/10000	30%
Product B	$4,500	=4500/10000	45%
Product C	$2,500	=2500/10000	25%
Total	$10,000		100%

If your data is in cells:

• A2 = 3000
• A3 = 4500
• A4 = 2500

The formula in B2 would be:

=A2/SUM($A$2:$A$4)

(The dollar signs keep the total range fixed when you copy the formula down)

Example: Survey Results
100 people were surveyed about their favorite color:

• Red: 35 people
• Blue: 28 people
• Green: 22 people
• Yellow: 15 people

To find what percentage chose Red:

=35/100($A$2:$A$4)

Result: 35%

Common Mistakes (And How to Avoid Them)

Mistake #1: The Result Shows 0.25 Instead of 25%

What happened: Excel calculated correctly, but the cell isn’t formatted to display as a percentage.

How to fix it:

1. Click the cell with your result
2. Look for the % button in the toolbar (usually in the “Home” tab)
3. Click it

Your 0.25 will instantly become 25%.

Alternative method:

• Right-click the cell
• Choose “Format Cells”
• Select “Percentage” from the category list
• Click OK

Mistake #2: The Formula Is Backwards

What happened: You divided total by part instead of part by total.

• Wrong: =200/50 when you meant to find what percentage 50 is of 200
• Right: =50/200

How to remember: Always ask yourself: “What am I trying to find as a percentage OF what?” The “of what” goes on the bottom (the denominator).

Example: “What percentage is 50 of 200?” → 50 divided by 200

Mistake #3: Mixing Percentages and Regular Numbers

What happened: You’re trying to calculate with a percentage but Excel is treating it as a whole number.

Example of the problem: You want to add 10% to a price of $100, so you type:

=100+10%

You expect $110, but you get $100.10.
Why: Excel reads 10% as 0.10, so you’re adding $0.10, not $10.

How to fix it:

=100*1.10

Or more clearly:

=100+(100*0.10)

Mistake #4: Not Using Cell References

What happened: You typed numbers directly into formulas, so when your data changes, you have to manually update every formula.

Less efficient way:

=50/200

Better way: Put 50 in cell A1, 200 in cell B1, then use:

=A1/B1

Why this matters: When A1 or B1 changes, your percentage updates automatically. This is crucial for dynamic reports, dashboards, or any data that changes over time.

Mistake #5: Forgetting to Lock Cell References When Copying Formulas

What happened: You copied a formula down a column, but the references shifted in ways you didn’t want.

Example: You want to calculate what percentage each value is of a total in cell B10.

If you write =A1/B10 in cell C1 and copy it down, it becomes:

• C2: =A2/B11 (Wrong! B11 isn’t your total)
• C3: =A3/B12 (Wrong again!)

How to fix it: Use dollar signs to “lock” the cell reference:

=A1/$B$10

Now when you copy it down:

• C2: =A2/$B$10 (Correct!)
• C3: =A3/$B$10 (Correct!)

Quick Reference: Which Formula Should I Use?

Here’s a simple decision tree:

“What percentage is X of Y?”

→ Use: =X/Y

“How much did this grow?”

→ Use: =(New-Old)/Old

“How much did this decrease?”

→ Use: =(Old-New)/Old

“What’s 15% of this number?”

→ Use: =Number*0.15 or =Number*15%

“What percentage does each item represent?”

→ Use: =Item/SUM(All Items)

Practical Tips for Working with Percentages in Excel

Tip #1: Keep Your Data Organized

Set up your spreadsheet with clear labels:

Item	Amount	Percentage
Completed	35	=B2/B5
Remaining	15	=B3/B5
Total	50

This makes it obvious what each number represents.

Tip #2: Use Separate Columns for Different Calculations

Don’t try to cram everything into one cell. For example:

Good layout:

• Column A: Product name
• Column B: Sales amount
• Column C: Percentage of total
• Column D: Growth vs last month

Confusing layout:

• Mixing calculations and labels in the same cells

Tip #3: Add Helper Columns for Complex Calculations

If you need to calculate percentage increase, create intermediate columns:

Month	Sales	Previous Month	Increase	% Growth
Jan	$5,000	–	–	–
Feb	$5,500	$5,000	$500	10%
Mar	$6,200	$5,500	$700	12.7%

This makes formulas easier to read and errors easier to spot.

Tip #4: Format First, Then Enter Formulas

If you know a column will contain percentages, format those cells as percentages before you start entering formulas. This saves time and prevents confusion.

Tip #5: Use Conditional Formatting for Visual Clarity

Excel can color-code your percentages automatically:

• Green for positive growth
• Red for decrease
• Yellow for values near a threshold

This makes trends jump out at a glance.

Real-World Example: Building a Simple Sales Dashboard

Let’s put everything together with a practical example.

Scenario: You’re tracking monthly sales for three products and want to see:

• Each product’s percentage of total sales
• Growth compared to last month
• How close you are to your sales goal

Here’s how to set it up:

	A	B	C	D	E
1	Product	This Month	% of Total	Last Month	% Growth
2	Product A	$3,500	=B2/$B$5	$3,000	=(B2-D2)/D2
3	Product B	$4,200	=B3/$B$5	$3,800	=(B3-D3)/D3
4	Product C	$2,800	=B4/$B$5	$3,200	=(B4-D4)/D4
5	Total	=SUM(B2:B4)		=SUM(D2:D4)
6
7	Goal	$12,000
8	Progress	=B5/$B$7

Format columns C and E as percentages.

What this shows you at a glance:

• Product B contributes 40% of total sales
• Product A grew by 16.7%
• Product C decreased by 12.5%
• You’ve reached 87.5% of your monthly goal

Wrapping Up

Percentages in Excel really come down to understanding just a few core formulas. Once you practice these basic patterns a few times, they’ll become automatic.

Remember:

• The basic formula is always some variation of part divided by total
• Format your results as percentages so they’re readable
• Use cell references instead of typing numbers directly
• Double-check that you’re dividing in the right direction

Start small: Pick one formula from this guide and try it with your own data. Once you’re comfortable, add another. Before you know it, you’ll be building dashboards and reports like a pro.

Need more help? Excel has built-in formula hints, just start typing = in a cell and Excel will suggest formulas and show you what values they need.

Good luck, and happy calculating!