OR
Syntax
OR(<Boolean>; <Boolean>; ...)
Description
Checks specified Boolean arguments to see if they are true or false. If any of the arguments are true the result is true. If all of the arguments are false the result is false. If null is an argument and all the other arguments are false, the result is an error. This function can support more than 255 arguments.
Instead of using the OR() function you can also use the || operator.
Examples
OR(Column1;Column2;Column3)
Column1 | Column2 | Column3 | Result |
|---|---|---|---|
true | true | true | true |
true | true | false | true |
true | false | false | true |
false | true | true | true |
false | false | true | true |
false | false | false | false |
true | true | null | true |
true | false | null | true |
false | true | null | true |
false | false | null | <error> |