The arguments logical_expression1, logical_expression2, and so on, must be logical expressions or values convertible to a logical value.
|
AND(logical_expression1, logical_expression2,...) Returns FALSE if at least one of the arguments is FALSE. Otherwise returns TRUE. |
|
OR(logical_expression1, logical_expression2,...) Returns TRUE if at least one of the arguments is TRUE. Otherwise returns FALSE. |
|
NOT(logical_expression) Returns negation of the logical_expression argument. |
|
CHOOSE(index,value1,value2,...) Returns value corresponding to the index. Index must be an integer value. |
|
FALSE() Returns logical FALSE value. |
|
IF(logical_expression,value_true, value_false) Returns value_true, when the result of the logical_expression is TRUE, or value_false when the result of the logical_expression is FALSE. |
|
ISBLANK(x) Returns TRUE if x contains only invisible characters or spaces. |
|
TRUE() Returns logical TRUE value. |
|
GT(x1,x2) Returns TRUE if x1 is greater than x2. Otherwise returns FALSE. |
|
GTE(x1,x2) Returns TRUE if x1 is equal to or greater than x2 . Otherwise returns FALSE. |
|
EQUAL(x1,x2) Returns TRUE if x1 is equal to x2. Otherwise returns FALSE. |
|
LTE(x1,x2) Returns TRUE if x1 is equal to or less than x2. Otherwise returns FALSE. |
|
LT(x1,x2) Returns TRUE if x1 is less than x2 . Otherwise returns FALSE. |