How to Calculate Percentage of a Number in Excel

Whether you're working out a sales commission, figuring out a discount, or analyzing survey results, calculating percentages in Excel is one of the most common spreadsheet tasks — and one of the most misunderstood. The good news: once you understand how Excel thinks about percentages, the formulas become intuitive fast.

What Excel Actually Means by "Percentage"

Before writing any formula, it helps to understand how Excel stores percentages internally. When you type 10% into a cell, Excel stores it as 0.10. That decimal representation is what gets used in calculations.

This matters because it changes how you write formulas. If a cell already contains a percentage-formatted value (like 10%), Excel handles the conversion automatically. If you're typing a raw number like 10 and treating it as "10 percent," you'll need to divide by 100 yourself — or Excel will treat it as the number 10, not 0.10.

The Core Formula: Percentage of a Number

The fundamental formula for finding a percentage of a number is:

= Number * Percentage 

Example: What is 15% of 200?

= 200 * 15% 

Result: 30

Or with cell references:

= A2 * B2 

Where A2 contains 200 and B2 contains 15% (formatted as a percentage).

If B2 contains the raw number 15 instead of a formatted percentage, adjust the formula:

= A2 * (B2 / 100) 

Both approaches produce the same result — the difference is how your data is structured.

Calculating What Percentage One Number Is of Another

This is slightly different. Here you're asking: what percentage does one value represent of a total?

Formula:

= Part / Total 

Example: 45 out of 180

= 45 / 180 

Result: 0.25 — format that cell as a Percentage (Home → Number → %) and it displays as 25%.

📊 This approach is useful for things like completion rates, market share breakdowns, and test scores.

Percentage Increase and Decrease

Calculating how much something has grown or shrunk between two values is a common variation.

Formula for percentage change:

= (New Value - Old Value) / Old Value 

Example: Sales went from 500 to 620.

= (620 - 500) / 500 

Result: 0.24 → formatted as 24% increase

For a decrease — say from 500 to 410 — the same formula returns a negative number, which Excel will display as -18% when percentage-formatted.

Applying a Percentage Increase or Decrease to a Number

If you want to find the value after applying a percentage change:

Increase by a percentage:

= Original * (1 + Percentage) 

Decrease by a percentage:

= Original * (1 - Percentage) 

Examples:

This is particularly useful for pricing models, salary adjustments, and forecasting.

Locking Cell References for Percentage Calculations Across Rows

When applying a single percentage to a list of numbers — say a 12% tax rate across 50 products — you'll want to lock the percentage cell so it doesn't shift as you drag the formula down.

= A2 * $B$1 

The dollar signs make B1 an absolute reference. A2 stays relative and adjusts row by row; $B$1 stays fixed. This is one of those Excel behaviors that trips up newer users more than any formula syntax does.

Formatting Matters as Much as the Formula

A calculated result sitting in a cell as 0.15 and the same result formatted as 15% are the same number — but they look completely different and can create confusion when building reports or sharing files.

Key formatting decisions that affect percentage work:

• Decimal places shown: 15% vs 15.00% vs 14.7% — choose based on the precision your data requires
• Percentage vs General format: If a cell shows 0.15 when you expect 15%, the formula is likely correct but the cell format is set to General or Number
• Negative percentages: Some contexts call for displaying these as red or in parentheses — that's a custom format, not a formula change

Variables That Affect How You Set This Up 🔧

The "right" approach to percentage calculations in Excel depends on several factors specific to your situation:

• How your source data is structured — are percentages pre-formatted or stored as raw integers?
• Whether you're pulling data from another system — imported CSV data often strips percentage formatting, leaving raw decimals or whole numbers
• Whether you need dynamic updates — static typed values vs. cell references that recalculate automatically
• Your Excel version — older versions handle some number formatting dialogs differently, though the core formula behavior is consistent across modern versions
• Collaboration context — files shared across teams or software (Excel, Google Sheets, LibreOffice) may render percentage formats differently

A setup that works perfectly in a standalone Excel file can behave unexpectedly when that same file feeds into a pivot table, a dashboard, or an external tool. How percentage values are stored — not just displayed — becomes important the moment your spreadsheet becomes part of a larger workflow.

Understanding the formulas themselves is the straightforward part. The more nuanced question is how those formulas fit into your specific data structure, workflow, and output requirements — and that answer looks different depending on what you're actually building.