Logical Functions

The functions that relate to logical operations are:

 

AND(expression1,expression2,...)

AND(column)

This function calculates logical AND.

For the arguments of this function, provide numeric (0 or 1) or logical values (TRUE or FALSE) for up to 255 arguments. You can also specify a single column instead of listing the values separately, or up to 255 columns or arrays.

 

FALSE()

This function returns the value for logical FALSE.

 

IF(valueTest,valueTrue,valueFalse)

This function performs a comparison and returns one of two provided values based on that comparison.

 

NOT(value)

This function reverses the logical value of its argument.

 

OR(expression1,expression2,...)

OR(column)

This function calculates logical OR. It returns TRUE if any of its arguments are true; otherwise, returns FALSE if all arguments are false.

Provide numeric (1 or 0) or logical values (TRUE or FALSE) for up to 255 arguments. You can also specify a single column instead of listing the values separately, or up to 255 columns or arrays.

 

TRUE()

This function returns the value for logical TRUE.

 

 

 

See Also:


Formula Functions