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>

Browser not supported