Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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>




  • No labels