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_test | An expression that results in TRUE or FALSE.
value_if_true | The value to be returned of the logical test is TRUE. If this parameter is omitted it defaults to 0.
value_if_false | The 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.

logical | The 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.