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.

**Table of Contents**hide

## 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.

- 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.

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

**Read 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-

`=SUM(C5:F5)`

Where,

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

- Hence, press
**Enter**to get the output.

- After that, 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)****How to Calculate Average Percentage Increase for Marks in Excel Formula****Calculate Average Percentage of Marks in Excel (Top 4 Methods)****How to Calculate Grade Percentage in Excel (3 Easy Ways)**

### 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-

`=G5/400`

Where,

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

- Now, hit the
**Enter**button to continue.

- Therefore, 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 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-

`=IF(H5>=90%,"A",IF(H5>=80%,"B",IF(H5>=70%,"C",IF(H5>=60%,"D","F"))))`

Where,

- 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.

- 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.

**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.

## Conclusion

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.