UK

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:

Formula for the Percentage of Marks in Excel = (Obtained Marks / Total Marks) * 100

The steps involved in calculating the percentage of marks in Excel sheet are given below.

• Set up your data:

  • Create separate columns for Subject, Obtained Marks, and Total Marks.
  • Input the corresponding data for each subject in these columns.

• Create a column for Percentage: Add a column named "Percentage."

• Apply the percentage calculation formula for Excel:

  • In the first cell of the "Percentage" column, enter the following formula (adjust cell references as needed):
    • = (B2/C2)*100
    • 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.

• Copy the formula: Copy the formula down the "Percentage" column for all subjects.

• Format as percentage:

  • Select the entire "Percentage" column.
  • Click on the percentage format button in the "Number" group on the Home tab.

For example, the percentage of marks calculated by applying the above formula in Excel will give results as in the table below.