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. |