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 is true. If any of the arguments in the columns are false the result is 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.
Instead of using the AND() function you can also use the && operator .
Examples
AND(Column1;Column2;Column3)
Column1 | Column2 | Column3 | Result |
---|---|---|---|
true | true | true | true |
true | false | false | false |
false | true | true | false |
false | false | false | false |
false | false | null | false |
true | true | null | <error> |