Page tree
Skip to end of metadata
Go to start of metadata

Syntax
AND(<Boolean>; <Boolean>, ...)

Description

Checks to see if all arguments in the specified columns are TRUE.  When all arguments specified in the function are TRUE the result will be TRUE.  If any of the arguments in the columns are FALSE the result will be FALSE.  All of the arguments in the columns must be in the Boolean data type. If one of the arguments is null and precedes the first FALSE in an argument, the calculation fails for that row. This function supports more than 255 arguments.

 

Examples:


If column1 isAND column2 isAND column3 isResult
TRUETRUETRUETRUE
TRUEFALSEFALSEFALSE
FALSETRUETRUEFALSE
FALSEFALSEFALSEFALSE
FALSEFALSEnullFALSE
TRUETRUEnull<error>


Instead of using the AND() function you can also use the && operator.

  • No labels