How to calculate percentage of marks in Excel?

<p>You can make calculations like calculating the percentage of marks in Excel sheet using certain formulas. To calculate the percentage of marks in Excel, the formula that you will is:</p><p><strong>Formula for the Percentage of Marks in Excel = (Obtained Marks / Total Marks) * 100</strong></p><p>The steps involved in calculating the percentage of marks in Excel sheet are given below.</p><p>&nbsp;</p><ul><li><p><strong>Set up your data:</strong></p><ul><li>Create separate columns for Subject, Obtained Marks, and Total Marks.</li><li>Input the corresponding data for each subject in these columns.</li></ul></li><li><p><strong>Create a column for Percentage:</strong></p><ul><li>Add a column named "Percentage."</li></ul></li><li><p><strong>Apply the percentage calculation formula for Excel:</strong></p><ul><li>In the first cell of the "Percentage" column, enter the following formula (adjust cell references as needed):<ul><li>= (B2/C2)*100</li><li>Here, B2 is the cell containing the obtained marks for the first subject, and C2 is the cell containing the total marks for the same subject.</li></ul></li></ul></li><li><p><strong>Copy the formula:</strong></p><ul><li>Copy the formula down the "Percentage" column for all subjects.</li></ul></li><li><p><strong>Format as percentage:</strong></p><ul><li>Select the entire "Percentage" column.</li><li>Click on the percentage format button in the "Number" group on the Home tab.</li></ul></li></ul><p>For example, the percentage of marks calculated by applying the above formula in Excel will give results as in the table below.&nbsp;</p><table dir="ltr" border="1" cellspacing="0" cellpadding="0"><colgroup><col width="100"><col width="83"><col width="143"></colgroup><tbody><tr><th colspan="4">Calculation of Percentage of Marks in Excel</th></tr><tr><th>Subject</th><th>Obtained Marks</th><th>Total Marks</th><th>Percentage</th></tr><tr><td>Math</td><td>85</td><td>100</td><td>85%</td></tr><tr><td>Science</td><td>72</td><td>100</td><td>72%</td></tr><tr><td>English</td><td>90</td><td>100</td><td>90%</td></tr></tbody></table>

0 Upvotes 0 Upvotes 0 Downvotes

• • Report Abuse
• Comment