Logical functions
NAME | DESCRIPTION |
---|---|
Returns TRUE if all the conditions are TRUE | |
Returns TRUE if the list of values being searched is in the array | |
Returns the logical value TRUE if the value argument is a reference to an empty cell | |
Returns the logical value TRUE if the value argument is a reference to an empty cell | |
Returns the logical value TRUE if the value argument is a valid number | |
Changes FALSE to TRUE and TRUE to FALSE | |
Returns TRUE if any of the arguments are TRUE and FALSE only if all arguments are FALSE | |
Returns a logical 'Exclusive OR' of all the arguments |
Logical Operators
TITLE | OPERATORS | DESCRIPTION |
---|---|---|
AND | && | Logical AND |
OR | || | Logical OR |
Last updated