How to Use IF with AND in Excel (Multiple Condition Formula)

How to Use IF with AND in Excel (Multiple Condition Formula)

Combining IF and AND in Excel lets you test multiple conditions in a single formula. This is super useful for decision-making formulas like grading, approval logic, and status checks.

📘 Syntax:

=IF(AND(condition1, condition2), value_if_true, value_if_false)

✅ Example:

Suppose you want to assign “Pass” if a student scored more than 40 in both subjects (Math in A2, Science in B2):

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

🎯 Common Use Cases:

• Checking if multiple conditions are met (e.g., both sales target and attendance are achieved)
• Validating user input or data
• Conditional formatting triggers

💡 Bonus Tip:

Combine IF + AND with ISBLANK() or OR() for advanced scenarios.

🛠 Combine With:

• OR() – for either/or logic
• IFERROR() – for clean results when errors occur

Ready to boost your logic building in Excel? Follow ScriptDataInsights for more clear Excel tutorials.