How to Compute Score Percentage in Excel

Updated 6 November 2026 · Standard formula, shown below

This guide shows you how to turn raw scores into percentages in Microsoft Excel, whether you’re grading tests, tracking sales targets, or analyzing survey results. You’ll learn the basic formula, how to format the results, and how to handle common pitfalls like blank cells or weighted scores. All you need is Excel (2010 or later) and your data in a spreadsheet.

What You’ll Need

Microsoft Excel (desktop or online version)
A list of scores (e.g., points earned)
A corresponding list of total possible points (or a single total)

Step-by-Step

Open your data in Excel. Make sure your scores are in one column (e.g., Column A) and the total possible points are in the next column (Column B). If you have a single total for all scores, you can put it in a separate cell (e.g., B1) and use absolute references.
Click on the first cell where you want the percentage to appear. This is usually in Column C, next to the first score.
Type the formula: =A2/B2 (assuming your first score is in A2 and total in B2). If you have a single total in B1, use =A2/$B$1 — the dollar signs lock the reference so it doesn’t change when you copy the formula.
Press Enter. Excel will show a decimal number (e.g., 0.85 for 85%).
Format as a percentage. Select the cell (or the whole column), then go to the Home tab, find the Number group, and click the % symbol. You can also press Ctrl+Shift+% (Windows) or Cmd+Shift+% (Mac).
Adjust decimal places if needed. Click the Increase Decimal or Decrease Decimal buttons in the same Number group to show more or fewer digits (e.g., 85.3% vs. 85%).
Copy the formula down. Click the small square at the bottom-right corner of the cell (the fill handle) and drag it down to fill the formula for all rows. If you used absolute references (like $B$1), they will stay fixed; relative references (like B2) will adjust per row.
For a quick percentage of a single score: If you just need one percentage, type =score/total in any empty cell, format as percentage, and you’re done.

Common Mistakes

Not formatting as a percentage. If you see 0.85 instead of 85%, you haven’t applied the percentage format. The underlying value is correct, but the display isn’t.
Using the wrong total. Double-check that the total in Column B matches the maximum possible score for each row. Mixing up totals (e.g., using 50 for a 100-point test) will give wrong percentages.
Dividing by zero or a blank cell. If the total is 0 or empty, Excel will show #DIV/0!. Make sure every row has a total.
Forgetting absolute references. If you use =A2/B1 and copy down, B1 will become B2, B3, etc., which is usually wrong. Use $B$1 to lock it.

Tips

Use the keyboard shortcut. Ctrl+Shift+% (Windows) or Cmd+Shift+% (Mac) applies percentage formatting instantly.
Display zero decimal places for a clean look. If you don’t need fractions of a percent, click Decrease Decimal twice to show whole numbers.
Handle blank totals gracefully. Use the IFERROR function: =IFERROR(A2/B2, "") to leave the cell blank if there’s an error.
Use a single total for all rows. If every score is out of the same total (like 100), put that total in a separate cell and use absolute references. This makes it easy to change the total later.
For weighted scores, use SUMPRODUCT. If different assignments have different weights (e.g., homework 30%, midterm 30%, final 40%), calculate the weighted percentage with =SUMPRODUCT(scores_range, weights_range) and format as percentage.

Troubleshooting

You see #DIV/0! error. This means the total is zero or empty. Check the total cell and make sure it contains a number. If a total is genuinely zero, decide how to handle it (e.g., leave blank or use IFERROR).
The percentage looks wrong (e.g., 8500%). This usually means the total is much smaller than the score, or you divided the wrong way. Check that you’re dividing score by total, not total by score.
Copying the formula gives incorrect results. If the total reference changes when you copy down, you forgot the dollar signs. Edit the formula to use $B$1 instead of B1.
Excel shows a decimal like 0.85 but you want 85%. Select the cell, go to the Home tab, and click the % symbol. If it still shows 0.85, the cell might be formatted as text — change the number format to General first, then apply percentage.
You need to round to a specific number of decimals. Use the ROUND function: =ROUND(A2/B2, 2) for two decimal places (as a decimal), then format as percentage. Or just use the Increase/Decrease Decimal buttons.

Frequently Asked Questions

How do I calculate a percentage of a total in Excel?

To find what percentage one number is of another, divide the part by the whole and format as percentage. For example, =15/50 gives 0.3, which formatted as % shows 30%.

How do I calculate a percentage increase or decrease in Excel?

Use the formula =(new_value - old_value) / old_value. Format the result as a percentage. For example, if sales went from 100 to 120, =(120-100)/100 gives 0.2, or 20% increase.

How do I calculate a weighted percentage in Excel?

Use the SUMPRODUCT function. For example, if scores are in A2:A4 and weights in B2:B4, use =SUMPRODUCT(A2:A4, B2:B4)/SUM(B2:B4) and format as percentage. This gives the weighted average.

Why is my percentage showing as a decimal like 0.85?

That’s because the cell is not formatted as a percentage. Select the cell, go to the Home tab, and click the % symbol. The underlying value is correct; only the display changes.

How do I calculate a percentage of a number in Excel?

To find e.g., 20% of 50, type =50*20% or =50*0.2. The result will be 10. You can also use =50*20/100.

Can I calculate a percentage without a total column?

Yes, if you have a single total, use an absolute reference like =A2/$B$1. If you have no total at all, you need to define what 100% means — otherwise a percentage has no meaning.

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