| Name: |
AND |
| Syntax: |
AND(<logical>[,<logical>]*) |
| Description: |
Returns the result of the logical AND of all arguments. Non-logical arguments are ignored. |
| Version: |
1.0.2 |
| Example: |
AND(a1,a2)
AND(a1:b3)
AND(a1>5,a1<10) |
| Name: |
FALSE |
| Syntax: |
FALSE() |
| Description: |
Returns the logical constant FALSE. |
| Version: |
1.0.2 |
| Example: |
FALSE() |
| Name: |
IF |
| Syntax: |
IF(<logical>,<true_value>,<false_value>) |
| Description: |
Evaluates the first argument, which must be a logical value, and returns the second argumnt if this is true and the third argument if it is false. |
| Version: |
1.0.2 |
| Example: |
IF(a1,a2,a3)
IF(a1>=0,"POSITIVE","NEGATIVE") |
| Name: |
IFERROR |
| Syntax: |
IFERROR(<value>,<error_value>) |
| Description: |
If the first argument is not an error then return this first argument, otherwise return the second argument. |
| Version: |
1.0.2 |
| Example: |
IFERROR(a1,"A1 HAS A PROBLEM") |
| Name: |
NOT |
| Syntax: |
NOT(<logical>) |
| Description: |
Returns the result of the logical NOT of the one argument. |
| Version: |
1.0.2 |
| Example: |
NOT(a1)
NOT(a1=6) |
| Name: |
OR |
| Syntax: |
OR(<logical>[,<logical>]*) |
| Description: |
Returns the result of the logical OR of all arguments. Non-logical arguments are ignored. |
| Version: |
1.0.2 |
| Example: |
OR(a1,a2)
OR(a1:b3)
OR(a1<5,a1>10) |
| Name: |
TRUE |
| Syntax: |
TRUE() |
| Description: |
Returns the logical constant TRUE. |
| Version: |
1.0.2 |
| Example: |
TRUE() |