Type in Google’s function list
Operator functions
Operators that Google’s list prints with a call syntax. Google prints 17 Operator function(s) in its Google Sheets function list.
| Function | Syntax as printed | Description from Google Docs Editors Help |
|---|---|---|
| ADD | ADD(value1, value2) | Returns the sum of two numbers. Equivalent to the `+` operator. |
| CONCAT | CONCAT(value1, value2) | Returns the concatenation of two values. Equivalent to the `&` operator. |
| DIVIDE | DIVIDE(dividend, divisor) | Returns one number divided by another. Equivalent to the `/` operator. |
| EQ | EQ(value1, value2) | Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. |
| GT | GT(value1, value2) | Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator. |
| GTE | GTE(value1, value2) | Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator. |
| ISBETWEEN | ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive) | Checks whether a provided number is between two other numbers either inclusively or exclusively. |
| LT | LT(value1, value2) | Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator. |
| LTE | LTE(value1, value2) | Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator. |
| MINUS | MINUS(value1, value2) | Returns the difference of two numbers. Equivalent to the `-` operator. |
| MULTIPLY | MULTIPLY(factor1, factor2) | Returns the product of two numbers. Equivalent to the `*` operator. |
| NE | NE(value1, value2) | Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator. |
| POW | POW(base, exponent) | Returns a number raised to a power. |
| UMINUS | UMINUS(value) | Returns a number with the sign reversed. |
| UNARY_PERCENT | UNARY_PERCENT(percentage) | Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`. |
| UNIQUE | UNIQUE(range, by_column, exactly_once) | Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. |
| UPLUS | UPLUS(value) | Returns a specified number, unchanged. |
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.