Google Sheets operator functions
Operator functions in Google Sheets, explained with live examples.
17 operator functions in Google Sheets — 0 documented in depth so far, the rest indexed below and landing every week.
All Google Sheets operator functions
The full set — deep dives on the way.
- ADD
- Returns the sum of two numbers. Equivalent to the `+` operator.
- CONCAT
- Returns the concatenation of two values. Equivalent to the `&` operator.
- DIVIDE
- Returns one number divided by another. Equivalent to the `/` operator.
- EQ
- Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator.
- GT
- Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator.
- GTE
- Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator.
- ISBETWEEN
- Checks whether a provided number is between two other numbers either inclusively or exclusively.
- LT
- Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.
- LTE
- Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator.
- MINUS
- Returns the difference of two numbers. Equivalent to the `-` operator.
- MULTIPLY
- Returns the product of two numbers. Equivalent to the `*` operator.
- NE
- Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.
- POW
- Returns a number raised to a power.
- UMINUS
- Returns a number with the sign reversed.
- UNARY_PERCENT
- Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.
- UNIQUE
- 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
- Returns a specified number, unchanged.
More Google Sheets function categories