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.

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

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

thank so much I enjoy your teaching approach even a novices will understand it, just that I could not access paid course due to word press troubleshooting issue

Hello

Ayokanmi,Thanks for your appreciation. You are most welcome. Our paid courses are in Udemy not in WordPress. But we have 7500++ free tutorials and 340+ YouTube videos. You can explore these learning materials for free.

Regards

ExcelDemy