Absolutely! The IF function in Excel is designed to work seamlessly with logical operators like AND and OR to create more complex conditional statements. Here's how:

Using AND with IF:

The AND operator allows you to test multiple conditions, and the IF function will only return a value if all the conditions are TRUE.

Example:

```excel
=IF(A1>100 AND B1<5, "Both conditions met", "At least one condition not met")
```

In this example, the IF function checks if the value in cell A1 is greater than 100 and the value in cell B1 is less than 5. If both conditions are TRUE, it displays "Both conditions met"; otherwise, it displays "At least one condition not met".

Using OR with IF:

The OR operator allows you to test multiple conditions, and the IF function will return a value if any of the conditions are TRUE.

Example:

```excel
=IF(A1>70 OR B1="Pass", "Success", "Fail")
```

Here, the IF function checks if the value in cell A1 is greater than 70 or the value in cell B1 is equal to "Pass". If either condition is TRUE, it displays "Success"; otherwise, it displays "Fail".

Nesting IFs with Logical Operators:

You can even nest IF functions together with AND or OR to create even more intricate conditional logic.

Example:

```excel
=IF(A1>90, "Excellent",
IF(A1>70 AND B1>80, "Very Good", "Good"))
```

In this scenario, the IF function first checks if A1 is greater than 90. If so, it displays "Excellent". Otherwise, it checks if A1 is greater than 70 and B1 is greater than 80 using another IF with AND. If both conditions are met, it displays "Very Good"; otherwise, it displays "Good".

By combining the IF function with logical operators, you can significantly enhance the decision-making capabilities of your Excel formulas.