How Can We Help?
Google Sheets Formulas
SpreadsheetWeb Hub supports 37 Google Sheets-only formulas in this release. The table below lists the currently supported formulas that are specific to Google Sheets.
| Formula | Description |
|---|---|
| ABERAGE.WEIGHT | Returns the weighted average of a set of values. |
| ADD | Returns the sum of two numbers. |
| ARRAY_CONSTRAIN | Constrains an array result to a specified number of rows and columns. |
| ARRAYFORMULA | Displays values returned from an array formula across multiple rows or columns. |
| COUNTUNIQUE | Counts the number of unique values in a list or range. |
| DIVIDE | Returns the result of dividing one number by another. |
| EPOCHDATE | Converts an epoch value to a date. |
| EQ | Returns TRUE when two specified values are equal. |
| FLATTEN | Flattens values from one or more ranges into a single column. |
| GT | Returns TRUE when the first value is greater than the second value. |
| GTE | Returns TRUE when the first value is greater than or equal to the second value. |
| IMCOTH | Returns the hyperbolic cotangent of a complex number. |
| IMLOG | Returns the logarithm of a complex number. |
| IMTANH | Returns the hyperbolic tangent of a complex number. |
| ISBETWEEN | Checks whether a value is between two boundary values. |
| ISDATE | Checks whether a value is a valid date. |
| ISEMAIL | Checks whether a value is a valid email address. |
| ISURL | Checks whether a value is a valid URL. |
| JOIN | Combines values from one or more arrays using a specified delimiter. |
| LT | Returns TRUE when the first value is less than the second value. |
| LTE | Returns TRUE when the first value is less than or equal to the second value. |
| MARGINOFERROR | Returns the margin of error for a range of values and a confidence level. |
| MINUS | Returns the difference between two numbers. |
| MULTIPLY | Returns the product of two numbers. |
| NE | Returns TRUE when two specified values are not equal. |
| POW | Returns a number raised to a specified power. |
| REGEXMATCH | Checks whether text matches a regular expression. |
| SORTN | Returns a specified number of items from a range after sorting. |
| SPLIT | Divides text around a specified delimiter and places the results in separate cells. |
| TO_DATE | Converts a number to a date value. |
| TO_DOLLARS | Converts a number to a dollar value. |
| TO_PERCENT | Converts a number to a percentage value. |
| TO_PURE_NUMBER | Converts a formatted numeric value to a pure number. |
| TO_TEXT | Converts a numeric value to text. |
| UMINUS | Returns a number with its sign reversed. |
| UNARY_PERCENT | Converts a number to a percentage by dividing it by 100. |
| UPLUS | Returns a number without changing its sign. |
For functions supported from Microsoft Excel workbooks, see Excel Formulas.
Note: Formulas available in both Microsoft Excel and Google Sheets are also supported in applications built from Google Sheets files.