The percentage formula in Excel is =A2/B2 with the cell formatted as Percentage, or =A2/B2*100 if you want a plain number such as 87.4. With 437 in A2 and 500 in B2, the first shows 87.4% and the second shows 87.4.
Pick one of the two styles and stay with it, because mixing them is the most common reason a sheet shows 8740%. This guide builds a class mark sheet column by column, then adds increase, difference, rounding and averages. Every formula below works the same way in Google Sheets.
At a glance
Percent of total
=A2/B2, then Home, Number group, Percentage formatPlain number
=A2/B2*100, General formatIncrease
=(B2-A2)/A2, Percentage formatRound to 2 places
=ROUND(A2/B2*100,2)X% of a number
=B2*18% or =B2*18/100Google Sheets
Same formulas, same results
=marks_cell/total_cell (format as %) or =marks_cell/total_cell*100
Use the first form with Percentage format, or the second form with General or Number format. Never both together.
Two ways to write the percentage formula in Excel
| Style | Formula in C2 | Cell format | Shows |
|---|---|---|---|
| Percent format | =A2/B2 | Percentage, 2 decimals | 87.40% |
| Plain number | =A2/B2*100 | General or Number | 87.4 |
The percent format style is better when other formulas will use the result, because the cell really holds 0.874 and multiplies correctly. The plain number style suits a printed result list where you want 87.4 without a % sign. Applying Percentage format to the second style shows 8740.00%, which is the classic slip.
- Put marks scored in column A and maximum marks in column B.
- In C2 type =A2/B2.
- Select column C and apply Percentage format with two decimals.
- Drag the fill handle down to copy the formula to every row.
- Check one row by hand against a calculator.
Build a class mark sheet percentage calculator
Set up one row per student and one column per subject. Here is a three student sample with five papers of 100 marks each.
| Row | C | D | E | F | G | H: Total | I: Percent |
|---|---|---|---|---|---|---|---|
| 2 (Student 1) | 78 | 85 | 69 | 91 | 74 | 397 | 79.4% |
| 3 (Student 2) | 66 | 72 | 58 | 80 | 70 | 346 | 69.2% |
| 4 (Student 3) | 92 | 88 | 95 | 90 | 97 | 462 | 92.4% |
- Total in H2: =SUM(C2:G2)
- Percent in I2: =H2/500 with Percentage format, or =H2/500*100 for a plain number
- Better still, put the maximum in one fixed cell, say K1 = 500, and use =H2/$K$1. The dollar signs keep K1 locked when you drag the formula down.
Check row 2 by hand: 78 + 85 + 69 + 91 + 74 = 397, and 397 / 500 = 79.4 percent. One manual check catches most setup errors.
Percentage increase, decrease and difference formulas
| Job | Formula (old in A2, new in B2) | Example |
|---|---|---|
| Percentage change or increase | =(B2-A2)/A2 | 142 to 167 shows 17.61% |
| Percentage decrease as a positive | =(A2-B2)/A2 | 120 to 96 shows 20.00% |
| Percentage difference | =ABS(A2-B2)/AVERAGE(A2,B2) | 72 and 88 shows 20.00% |
| Increase a number by 12% | =A2*(1+12%) | 450 gives 504 |
| Reduce a number by 15% | =A2*(1-15%) | 640 gives 544 |
All five use Percentage format for the result column, except the last two, which give ordinary numbers. For the meaning of each, see the percentage change and percentage difference pages.
Rounding, averages and pass or fail flags
- =ROUND(H2/500*100,2) stores 79.4 rounded to two decimals. Format only changes the display; ROUND changes the stored value.
- =AVERAGE(I2:I41) gives the class mean percentage for 40 students.
- =SUM(H2:H41)/(500*40) gives the class aggregate on total marks. With every student out of 500 it equals the average above.
- =SUMPRODUCT(C2:G2,C$1:G$1) multiplies marks by weights stored in row 1, useful for weighted schemes.
- =IF(I2>=$L$1,"Pass","Check") flags each student against a pass mark you type in L1 from your own rule book.
The average percentage calculator explains when a simple mean and a marks weighted figure differ.
Percentage calculator in Google Sheets
Google Sheets accepts every formula on this page without change. To apply percent format there, select the cells and use Format, then Number, then Percent, or the % button in the toolbar. The 0.0 buttons beside it add or remove decimals.
One difference worth knowing: when you type 18% straight into a cell, both programs store 0.18. So =B2*C2, with 18% in C2, gives 18 percent of B2 in either one. That is the cleanest way to keep a rate in its own cell for a whole column.
Errors in percentage sheets and their fixes
| What you see | Cause | Fix |
|---|---|---|
| 8740.00% | *100 and Percentage format together | Drop *100 or switch to General |
| The #DIV/0 error | Maximum cell is empty or zero | Fill the total, or wrap in =IFERROR(A2/B2,"") |
| Wrong answers lower down | Total cell moved when dragged | Lock it with $K$1 |
| Formula shows as text | Cell was formatted as Text, or a space before = | Set General format and retype |
| 0% for every row | Marks pasted as text from a portal | Use =VALUE(A2)/B2 or Text to Columns |
When a sheet is more than you need
A spreadsheet pays off for a whole class or for many semesters. For one student and one mark sheet, the marks percentage calculator is quicker. For checking answers from an OMR response sheet, the response sheet marks calculator works as an OMR sheet marks calculator with the exam's marking scheme built in. And for a single percent sum of any kind, the percentage calculator covers six kinds of sum.
Questions students ask
Which percentage formula in Excel works for marks?
Use =marks/total, for example =H2/500, and apply Percentage format. If you prefer a plain number, use =H2/500*100 and leave the format as General.
How to set up a percentage calculator in an Excel sheet?
Put marks in one column and the total in another, type =A2/B2 in the third, apply Percentage format and drag down. Lock a single total cell with dollar signs if every student has the same maximum.
Why does Excel show 8740% instead of 87.4%?
The formula already multiplies by 100 and the cell also has Percentage format, which multiplies again. Remove *100 or change the format to General.
What is the formula for percentage increase in Excel?
=(new-old)/old, for example =(B2-A2)/A2, with Percentage format. A negative result means a fall.
Do the same formulas work as a percentage calculator in Google Sheets?
Yes. Every formula here, including SUM, ROUND, ABS, AVERAGE and IF, works the same way in Google Sheets.
How do I round a percentage in Excel?
Wrap the formula in ROUND, such as =ROUND(A2/B2*100,2). Changing decimal places in the format only hides digits; ROUND actually stores the rounded value.