Logical Functions

ANDThe logical AND for any number of arguments.
FALSEThe logical value False.
IFThe value based on whether a certain condition is True or False.
IFERRORThe value or something else if it evaluates to an error.
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 a list of exact matches.
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 whether a certain condition is True or False.
IFERROR
The value or something else if it evaluates to an error.
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 a list of exact matches.
TRUE
The logical value True.
XOR
(2013) The logical exclusive OR for any number of arguments.

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