AND
Returns TRUE if all the conditions are TRUE
IN
Returns TRUE if the list of values being searched is in the array
ISBLANK
Returns the logical value TRUE if the value argument is a reference to an empty cell
ISEMPTY
ISNUMBER
Returns the logical value TRUE if the value argument is a valid number
NOT
Changes FALSE to TRUE and TRUE to FALSE
OR
Returns TRUE if any of the arguments are TRUE and FALSE only if all arguments are FALSE
XOR
Returns a logical 'Exclusive OR' of all the arguments
&&
Logical AND
||
Logical OR
Last updated 2 years ago
Was this helpful?