- 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.
Below list of Excel LOGICAL functions along with Syntax
| S.NO | Fn Name | No.of argmts | Syntax |
| 1 | AND | 1 | AND(logical1,[logical2],………..) |
| 2 | FALSE | 0 | FALSE() |
| 3 | IF | 3 | IF(logical_test,[value_if_true],[value_if_false]) |
| 4 | IFERROR | 2 | IFERROR(value,value_if_error) |
| 5 | IFNA | 2 | IFNA(value,value_if_na) |
| 6 | IFS | 2 | IFS(logical_test1,value_if_true1,[logical_test2,value_if_true2]….) |
| 7 | NOT | 1 | NOT(logical) |
| 8 | OR | 1 | or(logical,[logical1],[logical2]…..) |
| 9 | SWITCH | 3 | SWITCH(expression,value1,result1,[default_or_value2,result2]…..) |
| 10 | TRUE | 0 | TRUE() |
| 11 | XOR | 1 | XOR(logical1,[logical2],[logical3]……) |
