Type in Google’s function list
Logical functions
Functions that test conditions and choose between results. Google prints 13 Logical function(s) in its Google Sheets function list.
| Function | Syntax as printed | Description from Google Docs Editors Help |
|---|---|---|
| AND | AND(logical_expression1, [logical_expression2, ...]) | Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. |
| FALSE | FALSE() | Returns the logical value `FALSE`. |
| IF | IF(logical_expression, value_if_true, value_if_false) | Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. |
| IFERROR | IFERROR(value, [value_if_error]) | Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent. |
| IFNA | IFNA(value, value_if_na) | Evaluates a value. If the value is an #N/A error, returns the specified value. |
| IFS | IFS(condition1, value1, [condition2, value2], …) | Evaluates multiple conditions and returns a value that corresponds to the first true condition. |
| LAMBDA | LAMBDA(name, formula_expression) | Creates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares. |
| LET | LET(name1, value_expression1, [name2, …], [value_expression2, …], formula_expression ) | Assigns name with the value_expression results and returns the result of the formula_expression. The formula_expression can use the names defined in the scope of the LET function. The value_expressions are evaluated only once in the LET function even if the following value_expressions or the formula_expression use them multiple times. |
| NOT | NOT(logical_expression) | Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. |
| OR | OR(logical_expression1, [logical_expression2, ...]) | Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. |
| SWITCH | SWITCH(expression, case1, value1, [default or case2, value2], …) | Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met. |
| TRUE | TRUE() | Returns the logical value `TRUE`. |
| XOR | XOR(logical_expression1, [logical_expression2, ...]) | The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. |
Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Every function name in Google’s list is placed under one type; a function carries the type the list prints for it.