Excel LOGICAL functions Syntax List
Below list of Excel LOGICAL functions along with Syntax
| S.NO | Function Name | Syntax |
| 1 | AND | AND(logical1,[logical2],………..) |
| 2 | FALSE | FALSE() |
| 3 | IF | IF(logical_test,[value_if_true], [value_if_false]) |
| 4 | IFERROR | IFERROR(value,value_if_error) |
| 5 | IFNA | IFNA(value,value_if_na) |
| 6 | IFS | IFS(logical_test1,value_if_true1, [logical_test2, value_if_true2]) |
| 7 | NOT | NOT(logical) |
| 8 | OR | or(logical,[logical1],[logical2]) |
| 9 | SWITCH | SWITCH(expression,value1,result1, [default_or_value2,result2]) |
| 10 | TRUE | TRUE() |
| 11 | XOR | XOR(logical1,[logical2],[logical3]) |
- Click here to download the Excel Logical Functions Syntax List in Excel workbook
- Click here to download the Excel Logical Functions syntax List in PDF version.
