Advanced Excel - Logical Functions


Advertisements

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.

Advertisements