Logical Functions

ANDThe logical AND for any number of arguments.
FALSEThe logical value False.
IFThe value based on a logical test that is either True or False.
IFERRORThe value based on an error condition you specify.
IFNA(2013) The value True or False depending if the value is #N/A.
IFS(2019) The value based on multiple True or False conditions.
NOTThe opposite of a True or False value.
ORThe logical OR for any number of arguments.
SWITCH(2019) The value based on the first matching item.
TRUEThe logical value True.
XOR(2013) The logical exclusive OR for any number of arguments.
AND
The logical AND for any number of arguments.
FALSE
The logical value False.
IF
The value based on a logical test that is either True or False.
IFERROR
The value based on an error condition you specify.
IFNA
(2013) The value True or False depending if the value is #N/A.
IFS
(2019) The value based on multiple True or False conditions.
NOT
The opposite of a True or False value.
OR
The logical OR for any number of arguments.
SWITCH
(2019) The value based on the first matching item.
TRUE
The logical value True.
XOR
(2013) The logical exclusive OR for any number of arguments.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top