AND
Returns TRUE only if all the conditions are TRUE; otherwise, returns FALSE.
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 conditions 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 5 months ago