Written By Sophanith Dith
Last Updated June 17, 2026
Applies to Microsoft Excel 365 (Windows only)
Learning how to calculate percentages in Excel begins with one simple idea: divide the part by the total. Excel returns the result as a decimal number, which you can then display using the Percentage number format.
This calculation is useful for sales reports, budgets, discounts, test scores, completion rates, and many other everyday worksheets. Although Excel does not have a dedicated PERCENTAGE function, a basic division formula handles most percentage calculations.
Before applying percentage formatting, it is important to understand the number Excel calculates.
What the Percentage Formula Does
A percentage formula shows how one value compares with another value. It answers questions such as “What percentage of the budget has been spent?” or “What percentage of the sales target has been reached?”
The basic calculation divides the part by the total: =part/total.
For example, suppose Budget.xlsx contains a planned budget of $2,000 and actual spending of $1,500. Dividing 1,500 by 2,000 produces 0.75. When that result is formatted as a percentage, Excel displays 75%.
The formula returns a number rather than text. Percentage formatting only changes how the number appears; it does not change the stored value.
Understanding this basic calculation makes the formula structure easier to follow.
How to Calculate Percentages in Excel: Formula Syntax
The standard Excel percentage calculation formula uses the division operator rather than a named Excel function. You enter it in the same way as any other Excel formula.
=part/total
The two parts of the formula have different roles:
| Formula element | Meaning |
|---|---|
| part | The smaller value or amount you want to measure |
| / | The division operator |
| total | The complete amount against which the part is compared |
For worksheet values, the formula might look like this:
=B2/C2
Here, Excel divides the value in B2 by the value in C2.
If B2 contains 40 and C2 contains 50, Excel calculates 0.8. After you apply the Percentage number format, the cell displays 80%.
You normally should not multiply the formula by 100 when you plan to format the result as a percentage. Excel’s percentage format already displays 0.8 as 80%.
With the syntax established, a simple worksheet example shows how the formula works with actual cell references.
Basic Example: Calculate a Percentage of a Total
The simplest example compares an achieved amount with a target. This demonstrates the standard part-divided-by-total structure used when calculating percentages with Excel.
Suppose Sales_Report.xlsx contains the following data:
| A | B | C |
|---|---|---|
| Salesperson | Sales Completed | Sales Target |
| Dara | 40 | 50 |
To calculate Dara’s completion percentage:
- Click cell D2.
- Enter
=B2/C2. - Press Enter.
- Format D2 as a percentage using the steps in the next section.
Excel divides 40 by 50 and stores the result as 0.8. The cell displays 80% after percentage formatting is applied.
This formula works because 40 is the completed amount and 50 is the total target. Reversing those references would produce the wrong comparison.
Format the Formula Result as a Percentage
After you enter =B2/C2, Excel may display the result as a decimal, such as 0.8. To show it as 80%, select the formula cell, go to the Home tab, and click Percent Style (%) in the Number group.
The Percentage format changes how the result appears without changing its stored value. You can also use Increase Decimal or Decrease Decimal to control how many decimal places are displayed.
For a more detailed explanation of Excel number formats, including percentages, the Format Cells dialog box, and formatting options for different data types, see how to format percentages in Excel.
Once you understand how Excel stores and displays percentages, you can apply the same percentage concept to several common calculations.
Practical Percentage Examples
The basic percentage formula becomes more useful when you apply it to realistic worksheet data. The examples below show how to calculate a percentage of a total, a percentage amount, and percentage change.
Calculate the Percentage of a Budget Spent
Suppose B2 contains actual spending of $750, while C2 contains a total budget of $1,000.
Enter:
=B2/C2
Excel returns 0.75, which displays as 75% after percentage formatting.
This tells you that 75 percent of the available budget has been spent. You can copy the formula down when each row contains a different actual amount and budget.
For help extending calculations through a worksheet, see How to Use the Fill Handle in Excel.
Calculate a Percentage of an Amount
Sometimes you already know the percentage and need to calculate its monetary value. In this situation, multiply the amount by the percentage.
Suppose B2 contains a product price of $200, and C2 contains a discount rate of 15%.
Beginner Warning:
Enter the discount rate in C2 as 15% or 0.15, not as the whole number 15. Entering 15 would cause the formula to return $3,000 instead of $30.
Enter:
=B2*C2
Excel returns $30, which is the discount amount.
This formula calculates the discount amount. To find the discounted price, subtract that amount from the original price.
Calculate Percentage Change
Percentage change compares a new value with an original value. The difference between the values is divided by the original value.
Suppose B2 contains last month’s sales of $8,000, while C2 contains this month’s sales of $9,200.
Enter:
=(C2-B2)/B2
Excel calculates 0.15, which displays as 15%.
A positive result indicates an increase. A negative result indicates a decrease. The original value must be used as the denominator because the change is being measured against that starting amount.
For additional examples, Microsoft Support also explains how to calculate percentages in Excel, including percentages of totals and percentage changes.
These examples are straightforward, but several small mistakes can produce confusing results.
Common Percentage Formula Mistakes
Most percentage errors come from using the wrong cell reference or applying formatting incorrectly. Recognizing these problems will help you calculate percentages more reliably in Excel.
Mistake 1: Multiplying by 100 and Applying Percentage Formatting
A formula such as =(B2/C2)*100 may return 80. If you then apply percentage formatting, Excel displays 8000%.
Correction: Use =B2/C2, and then apply the Percentage format.
Beginner Warning:
Use either division with Percentage formatting or multiplication by 100 with a regular number format. Do not use both methods together.
Mistake 2: Dividing the Total by the Part
Using =C2/B2 instead of =B2/C2 reverses the calculation.
Correction: Identify the part first, then divide it by the total.
Mistake 3: Dividing by a Blank or Zero Cell
If the total cell is blank or contains zero, Excel returns #DIV/0!.
Correction: Check that the denominator contains a valid nonzero number. The IFERROR function can display a cleaner result, and it will be covered in a separate formula guide.
Mistake 4: Allowing a Fixed Total Reference to Move
Suppose every value in B2:B9 must be divided by the total stored in B10. Using =B2/B10 and copying it downward causes the denominator to move.
Correction: Lock the total reference:
=B2/$B$10
Mistake 5: Using Numbers Stored as Text
Excel may not calculate correctly when imported values are stored as text.
Correction: Convert the entries to real numbers before entering the formula.
After correcting a formula, the Undo and Redo shortcuts in Excel can help you quickly reverse an accidental edit.
A few related functions can also make percentage calculations easier to manage.
Related Formulas That Support Percentage Calculations
The core percentage-of-total calculation uses division, but several Excel functions can help prepare or manage the result. These functions support the percentage formula rather than replace it.
| Function | How it supports percentage calculations |
|---|---|
| SUM | Adds values to create the total used as the denominator |
| ROUND | Rounds a calculated percentage to a specified number of digits |
| IFERROR | Replaces errors such as #DIV/0! with a chosen value or message |
For example, you might total monthly sales with SUM and then divide one salesperson’s sales by that total. See How to Use the SUM Function in Excel for a focused explanation of that function.
Be careful when using ROUND. Changing the displayed decimal places through number formatting does not change the stored value, while ROUND changes the calculation result itself.
A short practice exercise will help you apply these calculations yourself.
Quick Practice
These exercises use XcelTips_Practice.xlsx and focus directly on entering, copying, and checking percentage formulas.
- Enter 45 in B2 and 60 in C2. In D2, enter
=B2/C2and format the result as a percentage. - Add three more rows of completed amounts and targets. Copy the formula from D2 down the column.
- Enter several sales values in B2:B6, place their total in B7, and calculate each value’s percentage of the total using an absolute reference to
$B$7.
After completing the practice, the following answers address common beginner questions.
Frequently Asked Questions (FAQs)
These questions clarify the difference between the formula, its result, and the Percentage number format.
Is there a percentage function in Excel?
No. Excel does not have a dedicated PERCENTAGE function. Most percentage calculations use division, such as =B2/C2.
How do I calculate a percentage of a total in Excel?
Divide the part by the total. For example, use =B2/C2 when B2 contains the part and C2 contains the total.
Why does my percentage formula show a decimal?
Excel stores percentages as decimal values. A result of 0.25 represents 25%. Apply the Percentage number format to change how it is displayed.
Should I multiply the result by 100?
Usually, no. When you use =B2/C2 and apply percentage formatting, Excel handles the display automatically.
How do I copy a percentage formula down a column?
Use relative references when each row has its own part and total. Use an absolute reference, such as $B$10, when every formula must divide by the same fixed total.
With these common questions answered, you are ready to apply percentage formulas more confidently in your own worksheets.
Conclusion
Understanding how to calculate percentages in Excel mainly requires choosing the correct part and total. For a percentage of a total, divide the part by the total with a formula such as =B2/C2, and then apply the Percentage number format.
Once you understand this basic structure, you can use percentage formulas to track budgets, measure progress toward targets, calculate discounts, and compare changes between old and new values. Practice with simple numbers first, and always check that the value after the division sign is the correct total or starting amount.
Next, learn how to use the IF function in Excel to test a condition and return different results based on whether that condition is true or false. You can also follow the Beginner Excel Learning Path to continue building your Excel skills in a structured order.