# LOGICAL

| Function | Example call                           | Expected result |
| -------- | -------------------------------------- | --------------- |
| AND      | AND(true, false, true)                 | FALSE           |
| FALSE    | FALSE()                                | FALSE           |
| IF       | IF(true, 'Hello!', 'Goodbye!')         | Hello!          |
| IFS      | IFS(false, 'Hello!', true, 'Goodbye!') | Goodbye!        |
| IFERROR  | IFERROR('#DIV/0!', 'Error')            | Error           |
| IFNA     | IFNA('#N/A', 'Error')                  | Error           |
| NOT      | NOT(true)                              | FALSE           |
| OR       | OR(true, false, true)                  | TRUE            |
| SWITCH   | SWITCH(7, 9, 'Nine', 7, 'Seven')       | Seven           |
| TRUE     | TRUE()                                 | TRUE            |
| XOR      | XOR(true, false, true)                 | FALSE           |