Calculate Percentages from Total in Excel

Updated 4 November 2026 · Standard formula, shown below

This guide shows you how to calculate percentages from a total in Microsoft Excel, whether you need the percentage of a specific value relative to a grand total, or you want to format existing numbers as percentages. You’ll learn the core formula, how to apply it correctly, and how to avoid common errors that produce wrong results.

What You’ll Need

Microsoft Excel (any recent version, including Excel 365, Excel 2019, or Excel for the web).
A worksheet containing the numbers you want to convert to percentages (for example, a list of sales figures and a cell with the total).
Basic familiarity with entering formulas and using cell references.

Step-by-Step

Identify the part and the total. Decide which number is the “part” (the value you want to express as a percentage) and which is the “total” (the whole, or the sum you compare against). For example, if you have sales of $250 in a month and total sales of $1,000, the part is 250 and the total is 1,000.
Place the part and total in cells. Enter the part in one cell (e.g., A2) and the total in another (e.g., B2). If your total is not already in a cell, you can use the SUM function later.
Write the basic percentage formula. In a new cell (e.g., C2), enter: =A2/B2. This divides the part by the total, giving a decimal (like 0.25).
Format the result as a percentage. With the formula cell selected, go to the Home tab, find the Number group, and click the % symbol. Alternatively, press Ctrl+Shift+% on Windows or Cmd+Shift+% on Mac. Excel will multiply the decimal by 100 and add a percent sign.
Adjust decimal places if needed. Click the Increase Decimal or Decrease Decimal buttons (also in the Number group) to show more or fewer digits after the decimal point. For example, 0.2534 can be shown as 25.3% with one decimal place.
Use absolute references when copying the formula. If you want to calculate percentages for multiple rows against the same total, make the total cell reference absolute by adding dollar signs. For instance, if the total is in B$2, write =A2/B$2. Then drag the fill handle down to copy the formula to other rows.
Calculate percentage of a subtotal using SUM. If your total isn’t in a single cell, you can compute it inside the formula. For example, to find what percentage the value in A2 is of the sum of A2:A10, use =A2/SUM(A2:A10) and format as percentage.
For percentage change between two numbers (not a part-of-total), use the formula =(new-old)/old. This gives the relative increase or decrease, which you then format as a percentage.

Common Mistakes

Forgetting to format as a percentage. If you just enter =A2/B2 and leave the cell as “General”, you’ll see 0.25 instead of 25%. Always apply the percent format.
Multiplying by 100 manually. Some users write =A2/B2*100 and then also apply the % format, resulting in 2500%. Let Excel handle the Ã—100 when you use the percent format.
Using relative references when copying. If you copy =A2/B2 down a column, the total reference changes to B3, B4, etc., which usually gives wrong results. Use $B$2 to lock the total.
Dividing by zero. If the total cell is empty or contains 0, Excel shows a #DIV/0! error. Ensure the total is a positive number.
Misidentifying the part and total. For example, if you have “discount” and “original price,” the percentage discount is discount/original, not original/discount.

Tips

Use the Percentage style for quick formatting. The % button is the fastest way; it applies two decimal places by default.
Use keyboard shortcuts. Ctrl+Shift+% (Windows) or Cmd+Shift+% (Mac) applies the percentage format without touching the mouse.
Check your total. If your total is a sum of many items, use the SUM function to avoid manual addition errors. For example, =A2/SUM(B2:B10).
Use the formula bar to verify. Click on a percentage cell and look at the formula bar to confirm the formula is exactly what you intended.
For large datasets, use a table. Convert your data to an Excel Table (Ctrl+T) so that formulas auto-fill and references stay correct when you add rows.

Troubleshooting

The result shows as a decimal, not a percentage. Apply the percent format as described in Step 4. If it still shows a decimal, the cell may have custom formatting; go to Format Cells (Ctrl+1) and select Percentage.

The result is 2500% instead of 25%. This happens when you manually multiplied by 100 and also applied the % format. Remove the *100 from the formula and just use =part/total.

#DIV/0! error appears. The total cell is empty or zero. Check that the total cell contains a number, and that it’s not blank. If the total is intentionally zero, you can use =IFERROR(A2/B2,0) to show 0% instead of an error.

Percentages don’t add up to 100%. This is usually due to rounding. If you have many rows, the displayed percentages may sum to 99% or 101% because of rounding. Increase decimal places to see more precision, or use the ROUND function in the formula: =ROUND(A2/B2,4).

Copying the formula gives wrong results. Check if you used absolute references for the total. If not, edit the formula to include $ signs, e.g., =A2/$B$2.

The percentage is negative. This happens when the part is negative or the total is negative. Ensure your data is correct. For percentage change, a negative result is expected if the new value is smaller.

Frequently Asked Questions

Q: How do I calculate what percentage one number is of another in Excel?
A: Divide the part by the total using =part/total, then format the cell as a percentage. For example, =A2/B2 formatted as % gives the percentage.

Q: How do I show a percentage without decimals?
A: After applying the % format, click the “Decrease Decimal” button until you reach 0 decimal places. Or use the ROUND function: =ROUND(A2/B2,2) and then format as %.

Q: Can I calculate a percentage of a total without a separate total cell?
A: Yes, use the SUM function inside the formula: =A2/SUM(A2:A10). This works well when the total is the sum of the same column.

Q: How do I calculate percentage increase or decrease between two numbers?
A: Use =(new-old)/old. For example, if old is in A1 and new is in B1, enter =(B1-A1)/A1 and format as percentage.

Q: Why does Excel show 0% even though the formula is correct?
A: This usually means the result is less than 0.5% and the cell is set to 0 decimal places. Increase decimal places to see the actual value, or check that the part is not zero.

Q: How do I make a percentage formula work for an entire column?
A: Write the formula in the first row, then drag the fill handle (the small square at the bottom-right of the cell) down. Make sure to use absolute references for the total, like $B$2, so it doesn’t change.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.