Excel Logical Functions
| FUNCTION | SYNTAX |
|---|---|
| AND | AND(logical1,logical2, ...) |
| FALSE | FALSE( ) |
| IF | IF(logical_test,value_if_true,value_if_false) |
| IFERROR | IFERROR(value,value_if_error) |
| IFNA | IFNA(value, value_if_na) |
| IFS | IFS(test1, value1, [test2, value2], ...) |
| NOT | NOT(logical) |
| OR | OR(logical1, [logical2], ...) |
| SWITCH | SWITCH(expression, val1/result1, [val2/result2], ..., [default]) |
| TRUE | TRUE() |
| XOR | XOR(logical1, [logical2],…) |