Excel LOGICAL functions Syntax List

Last modified date

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment