Returns true
if any inputs are true
; returns false
if all inputs are false
.
or( value, … )
value: (Boolean Array) A value or array of values that must be false for the function to return false.
Boolean
Arguments are cast to Boolean before or()
evaluates.
Multiple arguments are evaluated left-to-right.
As soon as the returned value of a value evaluation returns true
, the function returns true
.
By keeping common conditions on the left and complex edge cases on the right, you can improve function performance. That way, if an earlier simple function returns true
, evaluation of the later edge cases never occurs.
Null values that are part of input arrays are filtered out before evaluation.
Empty arrays evaluate to false
.
Empty text strings in a text array evaluate to false
, but empty text strings in an array with multiple data types are considered null values and are filtered out before evaluation.
Use functions to Pass Multiple Logical Values:
or(isleapyear(1996),isleapyear(1997))
returns true
Pass an Empty Array:
or({})
returns false
Pass an Array of Numbers:
or(1,2,"",3)
returns true
or(0,1,2,"",3)
returns true