Logical Functions

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.

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.