Logical Functions
- 2 minutes to read
This document briefly describes logical functions implemented in the XtraSpreadsheet.
| Name | Description | Syntax |
|---|---|---|
| AND | Returns TRUE if all of its arguments are TRUE; returns FALSE if one or more arguments evaluate to FALSE. | AND(logical1, [logical2], …) |
| FALSE | Returns the logical value FALSE. | FALSE() |
| IF | Checks a condition and returns one result if the condition is TRUE, and another result if the condition is FALSE. | IF(logical_test, [value_if_true], [value_if_false]) |
| IFS | Checks one or more conditions and returns a value of the first TRUE condition. If no TRUE conditions are found, this function returns #N/A error. | IFS([logical_test, value_if_true, ,…) |
| IFERROR | Checks whether or not a value (or expression) returns an error, and if so, the function returns a specified value; otherwise, the function returns the initial value. | IFERROR(value, value_if_error) |
| IFNA | Checks whether a value (or expression) resolves to #N/A, and if so the function returns a specified value; otherwise the function returns the initial value. | IFNA(value, value_if_na) |
| NOT | Reverses the logical value of its argument. | NOT(logical) |
| OR | Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE. | OR(logical1, [logical2], …) |
| SWITCH | Evaluates an expression against a list of values and returns the result of the first matching value. You can provide a default value to return if there is no match. If there are no matching values, and no default argument is supplied, the function returns the #N/A! error. | SWITCH(expression, value1, result1, default_or_value2, result2,…) |
| TRUE | Returns the logical value TRUE. | TRUE() |
| XOR | Returns a logical exclusive OR of all arguments. | XOR(logical1, [logical2],…) |