| 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]) |