Calculate Grade Using IF function in Excel (with Easy Steps)

Download the Practice Workbook

4 Simple Steps to Calculate a Grade Using the IF Function in Excel

Step 1 – Create a Dataset with Appropriate Information

• Suppose we have a list of Student Names in our workbook.

• Add the scores in different subjects for those students.

• Add the condition of the grades.

• We will add 3 columns where we will calculate the Total Marks, Percentage, and Grade Achieved.

Read More: How to Make a Grade Calculator in Excel (2 Suitable Ways)

Step 2 – Calculate the Total Marks

• Choose cell G5 and apply the following formula-

• Press Enter to get the output.

• Drag the fill handle down to fill all the cells.

Read More: How to Calculate Letter Grades in Excel (6 Simple Ways)

Similar Readings

• Excel Formula for Pass or Fail with Color (5 Suitable Examples)
• Calculate Average Percentage of Marks in Excel (Top 4 Methods)
• How to Calculate Grade Percentage in Excel (3 Easy Ways)

Step 3 – Calculate a Percentage from Total Marks

• Select cell H5.
• Insert the following.

We divided by 400 because we have four subjects with 100 max score each.

• Hit the Enter button to continue.

• Drag the fill handle down to get the percentage scored by all students.

Read More: How to Calculate Percentage of Marks in Excel (5 Simple Ways)

Step 4 – Apply the IF Function to Calculate the Grade

• Choose cell I5
• Put the following formula in the chosen cell:

• Press Enter and pull the fill handle down to fill the cells with the given condition.

• We have successfully calculated grades using the IF function in excel.

Read More: How to Apply Percentage Formula in Excel for Marksheet (7 Applications)

Related Articles

• How to Calculate Subject Wise Pass or Fail with Formula in Excel
• Make Result Sheet in Excel (with Easy Steps)
• How to Make Automatic Marksheet in Excel (with Easy Steps)
• Calculate Grades with Weighted Percentages in Excel