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