Logic
AND
Description: Returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.
Example:Β
AND(logical1, logical2, ...)
FALSE
Description: Returns a logical value of FALSE.
Example:Β
False(stringvalue)
IF
Description: Returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.
Example:Β
IF(logical_test, value_if_true, value_if_false)
NOT
Description: This function returns the reversed logical value.
Example:Β
NOT(logical)
OR
Description: Returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.
Example:Β
OR(logical1, logical2, ...)
TRUE
Description: Function returns a logical value of TRUE.
Example:Β
True(stringvalue)
XOR
Description: Returns the exclusive OR for the given arguments
Example:Β
XOR(logical_value1, logical_value2, ...)