Module logical 

Logical formula functions: TRUE, FALSE, IFERROR, IFNA, IFS, SWITCH, XOR.

Functions

fn_false

FALSE() - returns boolean FALSE.

fn_iferror

IFERROR(value, value_if_error) - returns value_if_error if the first arg is an error.

fn_ifna

IFNA(value, value_if_na) - returns value_if_na if the first arg is #N/A.

fn_ifs

IFS(condition1, value1, [condition2, value2], …) - evaluates conditions in order.

fn_switch

SWITCH(expression, value1, result1, [value2, result2], …, [default]) - matches a value.

fn_true

TRUE() - returns boolean TRUE.

fn_xor

XOR(logical1, [logical2], …) - returns TRUE if an odd number of arguments are TRUE.