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