SpreadCE Help


Logical functions
[ ] indicates optional parameters
AND(logical1, [logical2, ...])
FALSE()
IF(logical_test, [value_if_true], [value_if_false])
NOT(logical)
OR(logical1, [logical2, ...])
TRUE()


Logical functions

AND(logical1, [logical2, ...])
Returns TRUE if all of the input values are TRUE.

logical1, ...The values that you want to check.



FALSE()
Returns the logical value FALSE.


IF(logical_test, [value_if_true], [value_if_false])
Returns one of two other values depending no whether the logical test evaluates to TRUE or FALSE.

logical_testAn expression that results in TRUE or FALSE.
value_if_trueThe value to be returned of the logical test is TRUE. If this parameter is omitted it defaults to 0.
value_if_falseThe value to be returned of the logical test is FALSE. If this parameter is omitted it defaults to FALSE.



NOT(logical)
Returns TRUE if the input expression evaluates to FALSE, and vice versa.

logicalThe logical expression for which you want the opposite value.



OR(logical1, [logical2, ...])
Returns TRUE if any of the input values are TRUE.

logical1, ...The values that you want to check.



TRUE()
Returns the logical value TRUE.