The following tables provide a list of expressions of logical functions.
| AND | Description |
|---|---|
| Returns | TRUE if all its arguments are TRUE. |
| Syntax | and(number1, number2) Number1 and number2 should be logical values. |
| EQUAL | Description |
|---|---|
| Returns | TRUE if its arguments are EQUAL. |
| Syntax | number1 = number2 (number, number) Number1 and number2 are the numbers that you want to test. |
| GREATER | Description |
|---|---|
| Returns | TRUE if the first argument is greater than the second argument. |
| Syntax | number1 >= number2 (number, number)Number1 and number2 are the numbers that you want to test. |
| GREATER OR EQUAL | Description |
|---|---|
| Returns | TRUE if the first argument is greater than or equal to the second argument. |
| Syntax | number1 >= number2 (number, number)Number1 and number2 are the numbers that you want to test. |
| IF | Description |
|---|---|
| Specifies | A logical test to perform) |
| Syntax | if (test, value1, value2)Test is any value or expression that can be evaluated to TRUE or FALSE. Value1 is the value that is returned if test is TRUE.Value2 is the value that is returned if test is FALSE. |
| IS BETWEEN | Description |
|---|---|
| Checks | Checks if one value is between two others) |
| Syntax | isbetween |
| LESS | Description |
|---|---|
| Returns | TRUE if the first argument is less than the second argument) |
| Syntax | number1 < number2 (number, number) Number1 and number2 are the numbers that you want to test. |
| LESS OR EQUAL | Description |
|---|---|
| Returns | TRUE if the first argument is less than or equal to the second argument. |
| Syntax | number1 <= number2 (number, number)Number1 and number2 are the numbers that you want to test. |
| NAND | Description |
|---|---|
| Returns | FALSE if all its arguments are TRUE. |
| Syntax | nand(number1, number2)Number1 and number2 should be logical values. |
| NOR | Description |
|---|---|
| Returns | FALSE if any argument is TRUE. |
| Syntax | nor(number1, number2)Number1 and number2 should be logical values. |
| NOT | Description |
|---|---|
| Purpose | Reverses the logic of its argument. |
| Syntax | not(number) Number is a value or expression that can be evaluated to TRUE or FALSE. If number is FALSE, NOT returns TRUE. If number is TRUE, NOT returns FALSE. |
| NOT EQUAL | Description |
|---|---|
| Returns | TRUE if its arguments are NOT EQUAL. |
| Syntax | number1 <> number 2 (number 1, number 2)Number1 and number2 are the numbers that you want to test. |
| OR | Description |
|---|---|
| Returns | TRUE if any argument is TRUE. |
| Syntax | or(number1, number2)Number1 and number2 should be logical values. |