Advanced Excel - Logical Functions

Logical functions include the boolean operators and conditional tests, which will be an essential part of many working spreadsheets.

Logical Functions

The following table lists all the Logical functions −

S.No.	Function and Description
1	AND Returns TRUE if all its arguments are TRUE.
2	FALSE Returns the logical value FALSE.
3	IF Specifies a logical test to perform.
4	IFERROR Returns a different result if the first argument evaluates to an error.
5	IFNA Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
6	IFS Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
7	NOT Reverses the logic of its argument.
8	OR Returns TRUE if any argument is TRUE.
9	SWITCH Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
10	TRUE Returns the logical value TRUE.
11	XOR Returns a logical exclusive OR of all arguments.