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

Get FREE Advanced Excel Exercises with Solutions!

In Microsoft Excel, the IF function is basically used when you need output according to conditions. For calculating grades, there is no inbuilt formula in excel. Using the IF function we can easily calculate the grade whatever the conditions are. Today I am going to share with you how to calculate grade using IF function in excel.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

4 Simple Steps to Calculate Grade Using IF Function in Excel

In the following article, I have explained 4 simple steps to calculate grade using IF function in excel.

Step 1: Create Dataset with Appropriate Information

  • First, let’s start with creating a dataset. Suppose we have a list of Student Names in our workbook.

Calculate Grade Using IF function

  • To begin with, we will add scored numbers in different subjects for those students.

  • Now, we will add the condition of their grade according to scored number.

Calculate Grade Using IF function

  • In summary, we will add 3 columns where we will calculate the “Total Marks”, “Percentage”, and “Grade Achieved”. Finally, our dataset is complete.

Calculate Grade Using IF functionRead More: How to Make a Grade Calculator in Excel (2 Suitable Ways)

Step 2: Calculate Total Marks

  • Above all, in this step, we will sum up the total marks for each student.
  • In order to do so choose a cell (G5) and apply the following formula-


  • The SUM function returns the total sum value within a given string.

Calculate Grade Using IF function

  • Hence, press Enter to get the output.

  • After that, drag the “fill handle” down to fill all the cells.

Calculate Grade Using IF function

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

Similar Readings

Step 3: Calculate Percentage from Total Marks

  • Similarly, we will calculate the “Percentage” in a different column.
  • Just choose a cell to apply the formula. Here I have selected cell (H5).
  • Write the formula down-


  • In this formula, we have divided the total marks by “400” because for four subjects the total mark is 400.

Calculate Grade Using IF function

  • Now, hit the Enter button to continue.

  • Therefore, drag the “fill handle” down to get the percentage scored by all students.

Calculate Grade Using IF function

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

Step 4: Apply IF Function to Calculate Grade

  • Above all, it’s time to determine the “Achieved Grade”.
  • To do so choose a cell (I5) to write the formula down.
  • Put the formula in the chosen cell-


  • The IF function is used to check if the given condition is met and after that, the defined output will be displayed according to the condition.

Calculate Grade Using IF function

  • Similarly, press Enter and pull the “fill handle” down to fill the cells with the given condition.

  • In conclusion, we have successfully calculated grades using the IF function in excel.

Calculate Grade Using IF function

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

Things to Remember

  • While applying the formula you must end the formula with many brackets-() as there are many conditions put inside the cell.


In this article, I have tried to cover all the steps to calculate grade using IF function in excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram, BSc, Industrial and Production Engineering, Ahsanullah University of Science & Technology, has been working with the ExcelDemy project for 10 months. Currently working as as Excel and VBA content developer who provides authentic solutions to different Excel-related problems and writes amazing content articles regularly. He published almost 150 articles and has many more coming. He is very passionate about learning new things about Microsoft office Suite and Data analysis.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF