OR Function

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).
    • logical_expression2
    • ...
    —[optional]
    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.
Was this article helpful?
YesNo