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)

Column1Column2Column3Result
truetruetruetrue
truetruefalsetrue
truefalsefalsetrue
falsetruetruetrue
falsefalsetruetrue
falsefalsefalsefalse
truetruenulltrue
truefalsenulltrue
falsetruenulltrue
falsefalsenull<error>