Logical Functions

• Mar 19, 2021

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],…)