Excel LOGICAL functions Syntax List

  • 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.NOFn NameNo.of argmtsSyntax
1AND1AND(logical1,[logical2],………..)
2FALSE0FALSE()
3IF3IF(logical_test,[value_if_true],[value_if_false])
4IFERROR2IFERROR(value,value_if_error)
5IFNA2IFNA(value,value_if_na)
6IFS2IFS(logical_test1,value_if_true1,[logical_test2,value_if_true2]….)
7NOT1NOT(logical)
8OR1or(logical,[logical1],[logical2]…..)
9SWITCH3SWITCH(expression,value1,result1,[default_or_value2,result2]…..)
10TRUE0TRUE()
11XOR1XOR(logical1,[logical2],[logical3]……)