- 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]……) |