OR

Intermediate

Logical

Returns TRUE if any argument is TRUE. Used to test if at least one condition is met.

Syntax
=OR(logical1, [logical2], ...)
Parameters
logical1
Required
(logical)

First condition to test

logical2(logical)

Additional conditions (optional)

Examples
Real-world examples to help you understand how to use OR

Test any condition

=OR(A1>100, B1>100)

TRUE if either value exceeds 100

Result: TRUE or FALSE

Multiple criteria search

=OR(A1="Red", A1="Blue", A1="Green")

TRUE if A1 is any of the colors

Result: TRUE or FALSE

Combined with IF

=IF(OR(A1="", B1=""), "Missing data", "Complete")

Checks if any field is empty

Result: Text result

Common Use Cases
  • ✓Check alternative conditions
  • ✓Data validation
  • ✓Flexible filtering
  • ✓Exception handling
  • ✓Multi-option logic
Pro Tips
  • 💡Only one condition needs to be TRUE
  • 💡Can test up to 255 conditions
  • 💡Short-circuits on first TRUE
  • 💡Combine with IF for branching logic
Common Errors
  • ⚠️Using OR when AND is needed
  • ⚠️Not handling all FALSE case
  • ⚠️Confusion with XOR function
Related Formulas
ANDNOTIFXOR

Need a Custom OR Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula