How to Use the OR Function in Excel (With Logical Examples)

How to Use the OR Function in Excel (With Logical Examples)

The OR() function in Excel is used to return TRUE if any of the given conditions are TRUE. It’s essential for logical testing and decision-making within formulas like IF.

📘 Syntax:

=OR(logical1, [logical2], ...)

✅ Example – Check if a student passed either subject:

=OR(B2>=40, C2>=40)

This returns TRUE if the student scored 40 or more in either subject B2 or C2.

🔗 Combine with IF Function:

=IF(OR(B2>=40, C2>=40), "Pass", "Fail")

Displays "Pass" if the student passed in at least one subject.

🎯 Use Cases:

• Mark an employee as eligible if they meet any of multiple criteria
• Trigger reminders if any project deadline is overdue
• Highlight rows where any one of several values is met

🚀 Pro Tip:

Use OR inside conditional formatting for highlighting based on flexible conditions.

Master Excel logic faster – follow ScriptDataInsights for smart Excel hacks daily!