Intermediate
Logical
OR
Returns TRUE if at least one of the conditions given is true.
Compatibility: All Excel versions
Syntax
=OR(logical1, [logical2], ...)
Example
=OR(A1="Urgent",A1="High")
When to Use It
Use OR when any one of several conditions should trigger the same result — e.g. flag a task if its priority is "Urgent" or "High".