#### How to Use IF Function in Excel

You can learn here, what IF function is and how to use it.

Table of Contents

## IF Function Basics

IF function is one which are used the most often in Excel. IF is a logical function. But you can not only check TRUE / FALSE values.

IF Function contains from 3 parts:

- Logical test – IF function checks if this test is true or false in the cell
- Value if true – you can use it if logical test is true
- Value if false – put the argument here for the failed test

## Pass/Fail Evaluation

Consider a scenario where you have a table of exam results, and you want Excel to determine if a student passed or failed the exam automatically.

You can use the IF function for this purpose. Here’s the formula:

**=IF($C3>50,”PASSED”,”FAILED”)**

In this formula:

- $C3 represents the student’s score.
- The logical test checks if the score is greater than 50.
- If the score is greater than 50, Excel displays “PASSED”; otherwise, it shows “FAILED.”

## Grading System

Now, let’s tackle a more complex scenario where you want to assign grades to students based on their scores.

The grading criteria are as follows:

- A: >90 points
- B: >75 points
- C: >60 points
- D: >50 points
- E: ≤50 points

You can use nested IF functions to achieve this. Here’s the formula:

**=IF($C3>90,”A”,IF($C3>75,”B”,IF($C3>60,”C”,IF($C3>50,”D”,”E”))))**

This formula checks multiple logical tests sequentially to determine the appropriate grade for the student based on their score.

## Leave a Reply