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