AND

Logically checks to see if a list of boolean conditions are true or false. Returns true if the list of conditions are true, and false if one or more is false. Any null value is considered false.

Syntax

bool? AND(params bool?[] conditions)

Example

AND(COMPARE("Apples","Oranges"))

Will return false as the COMPARE returns false.

or

AND(COMPARE("Apples", "apples", true))

Will return true as the COMPARE returns true as "Apples" is the same as "apples" when the case is ignored.