How to Calculate Percentage of an Amount in Excel
Excel makes percentage calculations straightforward once you understand how the math maps to formulas. Whether you're working out a sales commission, a discount off a price, or what share of a budget one department represents, the underlying logic stays consistent — only the formula structure changes slightly depending on what you're solving for.
The Core Concept: What "Percentage of an Amount" Actually Means
A percentage is just a fraction expressed out of 100. When someone asks "what is 20% of 500?", they're asking you to multiply 500 × 0.20. Excel doesn't need a percent sign to do this — it just needs the decimal equivalent, or it needs to know you've formatted a cell as a percentage.
This distinction matters: a cell showing "20%" and a cell containing the number 0.20 are mathematically identical in Excel. When you type 20% directly into a cell, Excel stores it as 0.20 behind the scenes.
Basic Formula: Finding a Percentage of a Number
The simplest case — what is X% of a given amount — uses straightforward multiplication.
Formula structure:
= Amount * Percentage Example: What is 15% of $1,200?
= 1200 * 15% Result: 180
Or, if your amount is in cell A2 and your percentage is in cell B2:
= A2 * B2 Excel handles the rest, as long as B2 is formatted as a percentage or already contains a decimal value like 0.15.
Calculating What Percentage One Amount Is of Another
This is the reverse problem — you have two amounts and want to know the percentage relationship between them. For example: 240 is what percent of 960?
Formula structure:
= Part / Total Example: Sales this month were $240,000 against a $960,000 annual target. What percentage is complete?
= 240000 / 960000 Result: 0.25 — format the cell as a percentage and it displays as 25%.
If your values are in cells:
= B2 / A2 Then apply percentage formatting via the Home tab → Number group → the % button.
Percentage Change Between Two Amounts
Another common use case is calculating how much something has increased or decreased, expressed as a percentage.
Formula structure:
= (New Value - Old Value) / Old Value Example: Revenue went from $8,000 last month to $9,400 this month.
= (9400 - 8000) / 8000 Result: 0.175 → formatted as a percentage: 17.5% increase
A negative result indicates a decrease.
Applying a Percentage Increase or Decrease to an Amount
You often need to add or subtract a percentage from a base amount — applying a discount, calculating tax, or projecting growth.
| Goal | Formula |
|---|---|
| Add X% to an amount | = Amount * (1 + Percentage) |
| Subtract X% from an amount | = Amount * (1 - Percentage) |
Examples:
- Price is $250, apply a 12% markup:
= 250 * (1 + 12%)→ $280 - Price is $250, apply a 12% discount:
= 250 * (1 - 12%)→ $220
Using cell references:
= A2 * (1 + B2) This structure is cleaner than calculating the percentage separately and then adding — it's fewer steps and less prone to reference errors.
Absolute References Matter When Copying Formulas 📌
A common point where things go wrong: if your percentage value is in a single cell and you're applying it across a column of amounts, you need to lock that cell reference so it doesn't shift when you drag the formula down.
Use a dollar sign to create an absolute reference:
= A2 * $B$1 Here, $B$1 always refers to the cell holding your percentage, no matter where you copy the formula. Without it, dragging the formula down shifts the reference, pulling in wrong values or returning errors.
Formatting vs. Actual Values: A Variable That Catches People Out
How a cell is formatted changes how your formula behaves. If someone types 15 (not 15%) into a cell they intend to use as a percentage, a formula like = A2 * B2 will multiply by 15, not 0.15 — returning a number 100 times larger than expected.
The fix: Either type 15% directly, or format the cell as percentage before entering the number, or divide the raw number by 100 in your formula:
= A2 * (B2 / 100) This is one of those variables where different workflows — whether you're inheriting a spreadsheet from a colleague, pulling in data from another system, or building from scratch — can produce meaningfully different results from the same formula.
When It Gets More Complex 🔢
Once basic percentage formulas are working, some situations add layers:
- Percentage of a subtotal within a filtered list — requires
SUBTOTALorSUMIFto isolate the right values before dividing - Weighted percentages — when each component has a different weight, simple averaging doesn't work; each value must be multiplied by its weight first
- Running percentage totals — tracking cumulative progress toward a goal over time requires expanding ranges or helper columns
Each of these builds on the same foundation, but the formulas and cell-reference strategy shift based on how your data is structured.
The Variables That Shape Your Specific Situation
Excel's percentage formulas are consistent — but the right approach for any given task depends on factors specific to your spreadsheet:
- How your source data is formatted — raw numbers vs. pre-formatted percentages
- Whether the percentage is fixed or variable — a single rate vs. a column of different rates
- What you're calculating — share of total, change over time, or adjusted value all use different formula structures
- How the results will be used — display purposes, further calculations, or exports to other tools may require different formatting choices
The math is the same in every case. What changes is which formula structure fits your data layout, and whether your cell references and formatting are set up to match.