AND

Returns TRUE if all received values are TRUE. Note that those values can be variables or the result of functions and operators.

This is useful for conditions for IF and @IF for example.

Usage

AND(value1, value2...)

Parameters

value1	(Required) The first `TRUE` or `FALSE` value
value2	The second `TRUE` or `FALSE` value
...	You can give as many values as you want

Examples

Example	With these variables	Result
AND(country = “Canada”, age >= 18)	age is 22 country is "Canada"	TRUE
AND(country = “Canada”, age >= 18)	age is 10 country is "Canada"	FALSE
AND(country = “Canada”, age >= 18)	age is 22 country is "Belgium"	FALSE
AND(country = “Canada”, age >= 18)	age is 10 country is "Belgium"	FALSE
AND(country = “Canada”, age >= 18, ISNUMBER(FIND(“g”, name)))	age is 22 country is "Canada" name is "Analog"	TRUE
IF(AND(country = “Canada”, age >= 18), “verified”, “not verified”)	age is 22 country is "Canada"	“verified”

See also