Microsoft Excel is a powerful tool for students and teachers to manage grade sheets. Instead of using a manual calculator, you can automate thousands of calculations with one simple formula.
The Excel Percentage Formula
To calculate percentage in Excel, you don't actually need to multiply by 100 if you use the "Percentage" number format.
Method 1: Basic Formula
If your Obtained Marks are in cell A2 and Total Marks are in cell B2:
- Select cell
C2. - Type:
=A2/B2 - Press Enter.
- Click the % (Percent Style) button in the Home tab.
Method 2: Comprehensive Formula for Multiple Subjects
If you have marks in A2 through E2 and total marks in F2:
=SUM(A2:E2)/F2
Quick Tips
- Drag Fill: Once you've entered the formula for one student, click the small green square at the bottom-right of the cell and drag it down to apply to the whole class.
- Precision: You can increase or decrease decimal places using the buttons next to the % icon in Excel.
Frequently Asked Questions
Why did my Excel result show as a decimal like 0.85?
Change the cell formatting to 'Percentage' from the dropdown menu in the 'Number' group on the Home tab.
Can I use Google Sheets too?
Yes! The formulas =A2/B2 or =SUM(A2:E2)/F2 work exactly the same in Google Sheets.