### Example 1 – Nested IF Conditions

We’ll apply a nested formula to handle multiple **IF** conditions in Excel.

Consider a dataset where we want to set the **grades** for different students based on their **total** marks.

- Select cell
**F6**. - Enter the following formula:

`=IF(E6>160,"A",IF(E6>=150,"B",IF(E6>140,"C",IF(E6>130,"D",IF(E6<130,"F")))))`

- Press
**Enter**. - The value
**A**will appear in cell**F6**.

- Drag the
**Fill Handle**tool from cell**F6**to**F10**to apply the formula to other cells. - The resulting grades for all students will be displayed.

Here,

The formula that we used returns:

- Grade value
**A**if total marks are greater than or equal to**160** - Grade value
**B**if the total mark is greater than or equal to**150** - Grade value
**C**if the total mark is greater than or equal to**140** - Grade value
**D**if the total mark is greater than or equal to**130** - Grade value
**F**if the total mark is smaller than**130**.

**Read More: **VBA IF Statement with Multiple Conditions in Excel

### Example 2 – Multiple IF Condition in Excel with Logical Test

#### 2.1 AND Logic with IF Conditions

Let’s apply **multiple IF** conditions with the **AND** function.

Suppose we have a dataset where a student **passes** if he obtains marks **greater than or equal to 40** in both subjects.

- Select cell
**E6**. - Enter the following formula:

`=IF((AND(C6>=40, D6>=40)), "Pass", "Fail")`

- Press
**Enter**. - The output
**Pass**will appear in cell**E6**.

- Drag the
**Fill Handle**tool from cell**E6**to**E10**to fill down the formula. - The
**Pass/Fail**status for each student will be displayed.

Here, the formula returns **Pass **if both conditions are true otherwise it will return **Fail**.

**Read More:** IF with AND in an Excel Formula

#### 2.2 OR Logic with IF Condition

Let’s apply the **OR** function with multiple **IF** conditions.

Consider a dataset where a student **fails** if they get **less than or equal to 40** marks in **any one subject**.

- Select cell
**E6**. - Enter the following formula:

`=IF((OR(C6<=40, D6<=40)), "Fail", "Pass")`

- Press
**Enter**. - The output will appear in cell
**E6**.

- Drag the
**Fill Handle**tool from cell**E6**to**E10**to fill down the formula. - The
**Pass/Fail**status for each student will be displayed.

Here, the formula that we used returns **Fail **if any given condition is true otherwise it will return **Pass.**

#### 2.3 Combining AND & OR Logic with Multiple IF Condition

Let’s use multiple **IF** conditions with both **AND** and **OR** functions.

- Select cell
**E6**. - Enter the following formula:

`=IF(OR(AND(C6>=40, D6>=50), AND(C6>=35, D6>=45)), "Pass", "Fail")`

- Press
**Enter**. - The formula will return the value
**Pass**in cell**E6**.

- Drag the
**Fill Handle**tool from cell**E6**to**E10**to fill down the formula. - The
**Pass/Fail**status for each student will be displayed based on the combined conditions.

Here,

The formula returns:

**Pass**if the value in cells**C6**&**D6**is respectively**>=40**&**>=50**or**Pass**if the value in cells**C6**&**D6**is respectively**>=35**&**>=45**.

Any value that doesn’t meet the above conditions will return the value **Fail**.

**Read More: **Excel IF Function with 3 Conditions

### Example 3 – Apply Multiple IF Conditions with Different Excel Functions

Until now, we’ve explored how to use multiple **IF** conditions in Excel with **AND**/**OR** functions. In this example, we’ll learn how to combine multiple **IF** conditions with another function. Consider the following dataset, which contains marks for **three** **students** in **five** **subjects**. Our goal is to set the status of each student based on their total marks. To achieve this, we’ll use the **SUM function**.

- Select cell
**C11**. - Enter the following formula in that cell:

`=IF(SUM(C6:C10)>=350, "Good", IF(SUM(C6:C10)>=300, "Satisfactory", "Poor "))`

- Press
**Enter**. - The formula returns the value
**Good**in cell**C11**.

- Drag the
**Fill Handle**tool horizontally from cell**C11**to**E11**.

Here, the formula returns:

- The value
**Good**if the value of**SUM(C6:C10)**is greater than or equal to**350**. - The value
**Satisfactory**if the value of**SUM(C6:C10**) is greater than or equal to**300**. - The value
**Poor**if the value of**SUM(C6:C10)**is less than**300.**

**Read More: **VBA IF Statement with Multiple Conditions in Excel

**Download Practice Workbook**

You can download the practice workbook from here:

## Multiple IF Condition in Excel: Knowledge Hub

**How to Use PERCENTILE with Multiple IF Condition in Excel****Example of VLOOKUP with Multiple IF Condition in Excel**

**<< Go Back to Excel IF Function | Excel Functions | Learn Excel**