Percentages are among the most common calculations performed in Excel. They are used for discounts, growth rates, marks, budgets, sales analysis, completion rates, financial comparisons and many other everyday tasks.
The formula you need depends on the question. Are you finding a percentage of a number? Are you asking what percentage one value represents of another? Or are you measuring how much a value increased or decreased?
This guide covers the main percentage calculations in Excel and explains the mistakes that commonly produce incorrect results.
How Excel Stores Percentages
Excel stores a percentage as a decimal value. For example, 25% is stored as 0.25 and 7.5% is stored as 0.075. When a cell is formatted as a percentage, Excel displays the decimal in percentage form.
This is why multiplying a number by a cell containing 25% works naturally:
or
=A2*B2 when B2 contains 25%.
1. How to Calculate a Percentage of a Number
Suppose you want to find 20% of 500.
The result is 100.
If A2 contains 500 and B2 contains 20%, use:
This approach is preferable for spreadsheets because the percentage can be changed without rewriting the formula.
2. How to Find What Percentage One Number Is of Another
Suppose 52 is part of a total of 500. To find what percentage 52 represents:
Format the result as a percentage and Excel displays 10.4%.
With the part in A2 and the whole in B2:
This is commonly used for completion rates, category shares and marks.
3. How to Calculate Percentage Increase
If a value changes from 500 to 600, the increase is 100. To express that increase as a percentage of the original value:
The result is 20%.
With the original value in A2 and new value in B2:
The original value is the denominator because percentage change is measured relative to the starting value.
4. How to Calculate Percentage Decrease
If a value falls from 500 to 450:
The result is 10%.
Using cells A2 for the original value and B2 for the new value:
If B2 is larger than A2, the formula produces a negative result. That may be useful when you want the direction of change to remain visible.
5. How to Calculate Percentage Change With One Formula
If you want both increases and decreases to show naturally, use:
A positive result means an increase; a negative result means a decrease. For example, changing from 500 to 450 gives -10%.
6. How to Calculate Percentage of a Total
Suppose B2:B6 contains category values and B7 contains the total. To calculate the share represented by B2:
The dollar signs create an absolute reference. When you copy the formula down, the category cell changes from B2 to B3, B4 and so on, while the total remains B7.
7. How to Calculate a Percentage and Display the % Sign
If your formula returns 0.25, Excel may display 0.25 when the cell uses General formatting. Select the cell and apply Percentage formatting. Excel will display 25%.
You can usually change decimal places as well. For example, 25.678% can be displayed as 25.68% if two decimal places are selected.
8. Percentage Points vs Percentage Change
This distinction is important in reports.
If a conversion rate rises from 20% to 25%, the increase is 5 percentage points.
The relative percentage increase is:
So “up 5 percentage points” and “up 25%” describe different measurements.
9. How to Calculate a Discount Percentage
If an original price is in A2 and the discount percentage is in B2, the discount amount is:
The final price is:
Or, equivalently:
If you want to calculate the discount percentage from an original and sale price, use:
10. How to Calculate Percentage Completion
For a task where A2 is completed and B2 is the total:
Format it as a percentage. If 75 tasks are completed out of 100, the result is 75%.
11. How to Calculate Marks or Scores as a Percentage
If a student scores 420 out of 500:
Format the result as a percentage to display 84%.
With marks obtained in A2 and maximum marks in B2:
Common Percentage Errors in Excel
Using the wrong baseline
For percentage change, use the original value as the baseline. Dividing by the new value answers a different question.
Forgetting percentage formatting
A formula can be correct while the display is confusing. A result of 0.2 represents 20% when formatted as a percentage.
Dividing by zero
If the denominator is zero, an ordinary percentage calculation is undefined. Excel may display a division error. Handle zero values explicitly when your dataset can contain them.
Mixing percentages and whole numbers
A cell containing 20% has the numeric value 0.20. A cell containing 20 has the numeric value 20. They are not interchangeable.
How to Handle Zero and Blank Values
For reusable spreadsheets, you may want to avoid displaying errors when a denominator is blank or zero. One common pattern is:
This hides the error by returning a blank result. Use this thoughtfully: hiding an error can make a report look cleaner, but it can also conceal a data-quality problem. In analytical work, it may be better to explicitly flag the missing or zero denominator.
Percentage Calculation Example
Imagine a monthly report with these values:
| Month | Sales |
|---|---|
| January | 10,000 |
| February | 12,000 |
| March | 9,000 |
February's percentage increase from January is:
March's percentage change from February is:
The negative result indicates a decrease of 25%.
Which Formula Should You Use?
| Question | Formula |
|---|---|
| What is X% of Y? | =(X/100)*Y or =X%*Y |
| What percentage is A of B? | =A/B |
| Percentage increase/decrease | =(New-Original)/Original |
| Percentage of a total | =Part/Total |
| Discount amount | =Original*Discount% |
Use the Taskvora Percentage Calculator
If you are calculating percentages manually or checking an Excel result, the Taskvora Percentage Calculator provides a quick way to calculate common percentage values. You can also read the broader percentage calculation guide for formulas outside Excel.
Final Excel Percentage Checklist
- Identify whether you need a percentage of a number, percentage of a total or percentage change.
- Use the original value as the baseline for percentage change.
- Format the result as a percentage when appropriate.
- Use absolute references when a total must remain fixed while copying formulas.
- Check for zero and blank denominators.
- Distinguish percentage points from relative percentage change.
- Verify important results before using them in reports or decisions.
Once these distinctions are clear, most everyday percentage calculations in Excel become straightforward. The important part is not memorizing one formula; it is choosing the formula that matches the question being asked.
More Excel help: See IF in Excel, SUMIF and SUMIFS, COUNTIF and COUNTIFS, INDEX and MATCH, Remove Duplicates and PivotTables.
Related Excel guide: How to Clean Data in Excel.
Related Excel guide: How to Sort and Filter Data in Excel.