How to Use IF with AND/OR in Excel (Real-World Logic Examples)

How to Use IF with AND/OR in Excel (Real-World Logic Examples)

The IF function becomes more powerful when combined with AND and OR to evaluate multiple conditions.

🔹 Basic Syntax:

=IF(AND(condition1, condition2), "True Result", "False Result")

=IF(OR(condition1, condition2), "True Result", "False Result")

📊 Real-World Example: Student Grading

=IF(AND(A2>=50, B2>=50), "Pass", "Fail")

This checks if a student passed both subjects.

💼 Business Example: Discount Eligibility

=IF(OR(A2="Gold", B2>=5000), "Eligible", "Not Eligible")

This grants discount to Gold members or those spending over 5000.

💡 Pro Tip:

You can nest IF with AND and OR for more complex logic trees.

📌 Quick Recap:

• AND: All conditions must be TRUE
• OR: At least one condition must be TRUE
• IF: Returns result based on condition

Keep following ScriptDataInsights for more Excel logic tricks and formulas simplified!