OR()
Returns TRUE if any argument is true.
OR(logical1, [logical2], ...)OR evaluates a list of conditions and returns TRUE if at least one holds, FALSE only when every condition fails.
Like AND, it's most useful nested inside IF rather than used on its own — for example, flagging a row as urgent if either its priority is High or its due date has passed.
Arguments
- logical1
- The first condition to test.
- logical2, ...optional
- Additional conditions to test — any may be TRUE.
Examples
=OR(B2="High", C2<TODAY())→TRUE
TRUE if priority is High or the due date is already past.
=IF(OR(B2="High", C2<TODAY()), "Urgent", "Normal")→Urgent
OR nested inside IF.