Excel Logical Functions

This section will learn  how to use Excel’s  Logical Functions such as: AND, FALSE, IF, IFError, IFNA, etc.

AND – returns TRUE if all of arguments are TRUE, and it returns FALSE if any of arguments are FALSE.

OR – used to test multiple conditions and returns TRUE if any of the conditions are TRUE.

NOT – returns the opposite of a given logical or Boolean value.

FALSE – returns the logical value “FALSE”

TRUE – return the logical value TRUE.

IF – perform a logical test to return one value if the condition is TRUE and return another value if the condition is FALSE.

IFERROR – returns an alternate value you specify if a formula results in an error, or returns the result of the formula.

IFNA – returns an alternate value you specify if a formula results in an #N/A error, or returns the result of the formula.

SWITCH – ompares one value against a list of values, and returns the result corresponding to the first matching value.