Logical functions

IF

Returns the second argument if a condition is met, and the third one otherwise

IF(logical_test, value_if_true, [value_if_false])

IFERROR

Returns the validated value if it does not contain an error, otherwise returns the second argument

IFERROR(value_to_validate, value_if_error)

IFNA

Returns the value of the second argument if the first one contains the #N/A error. Otherwise the value of the first argument is returned

IFNA(value, value_if_na)

AND

Returns TRUE if all given conditions are met, and FALSE if at least one condition is not satisfied

AND(logical_test1, [logical_test2, ...])

OR

Returns TRUE if at least one given condition is met, and FALSE if none of the conditions are satisfied

OR(logical_test1, [logical_test2, ...])

TRUE

Returns the logical value TRUE

TRUE()

FALSE

Returns the logical value FALSE

FALSE()

SWITCH

Compares an expression with a list of possible values and returns the corresponding result when there is a match

SWITCH(expression, value1, result1, [value2, result2, ...], [default])