Used within another function to return true if at least one provided logical expression is true.
Sample Usage
IF(OR([Due Date]1 > [Due Date]2, [Due Date]1 > [Due Date]3), "Due Date 1 isn't the smallest", "Due Date 1 is the smallest")
Syntax
OR(
- logical_expression1
- []
- logical_expression2
- ...
- logical_expression1—An expression that evaluates to either true or false (boolean).
- —[optional]
- logical_expression2
- ...
Additional expressions that evaluate to true or false.
Usage Notes
- OR can be used directly in a boolean column (checkbox, flag, star) or can be used within another function—such as IF, SUMIF, COUNTIF, SUMIFS, and COUNTIFS.
- OR can be used directly in a boolean column (checkbox, flag, star) or can be used within an IF function.
- OR can also be used in conjunction with @cell, in the criterion of other functions such as SUMIF, COUNTIF, SUMIFS, and COUNTIFS.