By checking for a condition and delivering a result if it is **TRUE** or **FALSE**, **the IF function** enables us to logically compare a value to what we anticipate. What happens, however, if we need to test many conditions, where, for example, all conditions must be True or False (**AND**), or only one condition must be **True **or **False **(**OR**)?Â We can use **OR** and **AND** functions independently, but we will frequently see **the IF function** in combination with them. With that in mind, in this article, we learn **3** advanced examples to **use IF function **with** OR **and** AND statement **in** Excel**.

## Download Practice Workbook

Download this workbook and practice while going through the article.

## 3 Advanced Examples to Use IF Function with OR and AND Statement in Excel

Before we dive into the examples, letâ€™s first recap the most important part of the formula combination namely **the IF function**. Comparing thoroughly two or more logical conditions, **the IF function** returns **TRUE** or **FALSE** outputs. Furthermore, we will combine the **OR** and **AND** statements with **the IF function** with hands-on examples to understand better. To demonstrate, letâ€™s take a dataset that represents the financial states of various departments of an organization. Here, we add the proper conditions in row **12** to implement the formula properly.

### Example 1: Utilize IF Function with OR and AND Statement in Excel to Analyze Financial Data

The first example aims to analyze the financial data of the organization by combining **the IF function** with the **OR** and **AND** statements. Here, we will set **four** logical conditions. The first **two** conditions are in the **OR** statement and the other **two** are in the **AND** statement. Only one or both conditions can be true for the whole statement to be **TRUE** in the case of the **OR** statement. Alternatively, for the **AND** statement, both statements have to be true for the whole statement to be **True**. If the conditions are true we will flag the departments by displaying **Flag**. Otherwise, we will display **OK**. Letâ€™s see the formula combination below to do the analysis.

__Steps:__

- Firstly, in cell
**G5**, type the following formula combination.

`=IF(OR(C5>$C$12,D5>$D$12,AND(E5=$E$12,F5>$F$12)),"Flag","OK")`

- Further, press the
**Enter**or**Tab**keys to see the output**Flag**. - This represents the conditions are
**TRUE**for the Production department.

- Later, use the
**AutoFill tool**to obtain the rest of the outputs. - Thus, we obtain the results in our dataset with the combined formula.

**Formula Breakdown**

**OR(C5>$C$12,D5>$D$12**indicates the statement is**TRUE**either the**Budget**is**> 200,000**or**YTD**Spent is**> 100,000**.**AND(E5=$E$12,F5>$F$12)**represents the statement is**TRUE**if**E5**is**+****Yes**and**Overrun% > 20%**are true.**IF(OR(C5>$C$12, D5>$D$12, AND(E5=$E$12, F5>$F$12)),” Flag”, “OK”)**commands if the conditions are**TRUE**then display**Flag**otherwise**OK**.

**Read More: How to Use IF with AND Function in Excel (Formula + VBA)**

### Example 2: Apply IF Function with OR and AND Statement to Distribute Performance Bonuses

The objective of the second example is to apply **3** conditions using **OR** and **AND** statements with **the IF function** for the distribution of performance bonuses. The conditions are if the **Total **sales are **> 300,000** then give the employee a **1000** bonus. Also, if the **Total **sales are **> 295,000** and **Training** is **= Yes** then give him the bonus. Otherwise, do not give any bonus. Follow the instructions for implementation.

__Steps:__

- To begin with, type the following formula in cell
**G5**,

`=IF(OR(E5>$D$11,AND(E5>$E$11,F5=$F$11)),1000,0)`

- Pressing the
**Enter**key will display the output**0**.

- Now, drag the
**AutoFill tool**down to fill the rest of the cells in column**G**. - Lastly, we obtain the desired result.

**Formula Breakdown**

**OR(E5>$D$11**represents**Total**in column**E**has to be**> 300,000**for the statement to be**TRUE**.**AND(E5>$E$11, F5=$F$11)**indicates the statement is**TRUE**if both**Total > 295,000**and**Training = Yes**are true.**IF(OR(E5>$D$11, AND(E5>$E$11, F5=$F$11)),1000,0)**commands to print**1000**if**TRUE**otherwise**0**.

**Read More: ****How to Check If Cell Contains One of Several Values in Excel**

**Similar Readings**

**How to Use Multiple IF Statements in Excel Data Validation****Excel IF Statement with VLOOKUP for Multiple Conditions Range****How to Use If Statement Based on Cell Color in Excel (3 Examples)****Dynamic Data Validation List in Excel with IF Statement Condition****How to Use IF Statement with Not Equal To Operator in Excel**

### Example 3: Create Gradesheet Calculators Using IF Function with OR and AND Statement

In the final example, we will create a grade sheet calculator by applying logical conditions using **OR** and **AND** statements combined with **the IF function**. The conditions are the same as in the first example. We will know more about this below. Therefore, letâ€™s start following the instructions.

__Steps:__

- Initially, in cell
**G5**, write the following formula.

`=IF(OR(C5>$C$11,D5>$D$11,AND(E5=$E$11,F5>$F$11)),$G$12,$G$13)`

- Afterward, tap the
**Enter**key.

- Next, use the
**AutoFill tool**to get the rest of the results.

**Formula Breakdown**

**OR(C5>$C$11,D5>$D$11**indicates the statement is**TRUE**either the**Test-1**is**> 80**or**Test-2**is**> 75**.**AND(E5=$E$11,F5>$F$11)**represents the statement is**TRUE**if**E5**is**=****Yes**and**Attendance% > 70%**are true.**IF(OR(C5>$C$11, D5>$D$11, AND(E5=$E$11, F5>$F$11)),$G$12,$G$13)**commands if the conditions are**TRUE**then display**Passed**otherwise**Failed**.

**Notes**

- While using the formula, referencing an error cell will return a
**#VALUE!**error. - Moreover, keep in mind that the formulaâ€™s evaluation values do not contain
**commas**(**,**). Doing that will result in a**#VALUE!**error.

**Read More: ****How to Use If Then Else Statement in Excel VBA (4 Examples)**

## Conclusion

In conclusion, we have discussed some advanced examples of how to use **the IF function **with **OR** and **AND** statement in Excel with an example. Not to mention, our **ExcelDemy website** shows various simple problem-solving methods like this. Please, leave any further queries or recommendations in the comment box below.

## Related Articles

**How to Use Conditional Formatting If Statement Is Another Cell****Excel IF Statement Between Two Numbers (4 Ideal Examples)****How to Find Sum If Cell Color Is Green in Excel (4 Easy Methods)****Prepare IF Statement Contains Multiple Words in Excel****How to Use Wildcard with If Statement in Excel (5 Methods)****Show Cell Only If Value Is Greater Than 0 in Excel (2 Examples)****How to Use IF Statement with Yes or No in Excel (3 Examples)**