Google Sheets Formulas | SpreadsheetWeb Hub

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.