Logical Functions

ANDThe boolean True or False depending on multiple conditions.
FALSE(Compatibility) The logical value False.
IFThe value based on whether a condition is True or False.
IFERRORThe value or something else if it evaluates to an error.
IFNAThe value or something else if it evaluates to #N/A.
IFS(2019) New. The value based on multiple True or False conditions.
NOTThe opposite of a True or False value.
ORThe boolean True or False depending on multiple conditions.
SWITCH(2019) New. The value based on a list of exact matches.
TRUE(Compatibility) The logical value True.
XORThe boolean True or False depending on multiple conditions.
AND
The boolean True or False depending on multiple conditions.
FALSE
(Compatibility) The logical value False.
IF
The value based on whether a condition is True or False.
IFERROR
The value or something else if it evaluates to an error.
IFNA
The value or something else if it evaluates to #N/A.
IFS
(2019) New. The value based on multiple True or False conditions.
NOT
The opposite of a True or False value.
OR
The boolean True or False depending on multiple conditions.
SWITCH
(2019) New. The value based on a list of exact matches.
TRUE
(Compatibility) The logical value True.
XOR
The boolean True or False depending on multiple conditions.

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