Logo Docs
Logo Docs

OR

Returns TRUE if at least one of the values is 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

OR(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

OR(country = “Canada”, age >= 18)
age is 22
country is "Canada"

TRUE

OR(country = “Canada”, age >= 18)
age is 10
country is "Canada"

TRUE

OR(country = “Canada”, age >= 18)
age is 22
country is "Belgium"

TRUE

OR(country = “Canada”, age >= 18)
age is 10
country is "Belgium"

FALSE

OR(country = “Canada”, age >= 18, ISNUMBER(FIND(“g”, name)))
age is 10
country is "Belgium"
name is "Analog"

TRUE

IF(OR(country = “Canada”, age >= 18), “verified”, “not verified”)
age is 10
country is "Canada"

“verified”

See also