This document briefly describes logical functions implemented in the ASPxSpreadsheet.
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]) |
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], ...) |
TRUE |
Returns the logical value TRUE. |
TRUE() |
XOR |
Returns a logical exclusive OR of all arguments. |
XOR(logical1, [logical2],…) |