Logo Docs
Logo Docs

Function 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