Array

Function	Description
SUMX2MY2	Calculates the sum of the differences of the squares of values in two arrays.
SUMX2PY2	Calculates the sum of the sums of the squares of values in two arrays.
SUMXMY2	Calculates the sum of the squares of differences of values in two arrays.
TRANSPOSE	Transposes the rows and columns of an array or range of cells.
TREND	Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.
FREQUENCY	Calculates the frequency distribution of a one-column array into specified classes.
GROWTH	Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.
LINEST	Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method.
LOGEST	Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve.
MDETERM	Returns the matrix determinant of a square matrix specified as an array or range.
MINVERSE	Returns the multiplicative inverse of a square matrix specified as an array or range.
MMULT	Calculates the matrix product of two matrices specified as arrays or ranges.
SUMPRODUCT	Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
SORT	Sorts the rows of a given array or range by the values in one or more columns.
FILTER	Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.
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.
RANDARRAY	Returns a grid of random numbers between 0 inclusive and 1 exclusive. The grid size will match the provided rows and columns arguments. If neither rows nor columns are provided, then the grid will be size 1 x 1.
SEQUENCE	Returns a grid of sequential numbers starting at a specified start value and increasing by a specified step size. By default, the sequence starts at and increases by 1.

Data Mining

Function	Description
DM_TEXT_CUTWORD	Text segmentation. Split a series of words into a series of individual words
DM_TEXT_TFIDF	Use tf-idf algorithm for keyword extraction. Identify keywords from a series of text
DM_TEXT_TEXTRANK	Use TextRank algorithm to extract keywords. Identify keywords from a series of text

Database

Function	Description
DATA_CN_STOCK_CLOSE	According to the stock code and date, return the corresponding stock closing price of A shares.
DATA_CN_STOCK_OPEN	According to the stock code and date, return the opening price of stock.
DATA_CN_STOCK_MAX	According to the stock code and date, return the highest price of stock.
DATA_CN_STOCK_MIN	According to the stock code and date, return the lowest price of stock.
DATA_CN_STOCK_VOLUMN	According to the stock code and date, return the corresponding stock trading volume of A shares.
DATA_CN_STOCK_AMOUNT	According to the stock code and date, return the corresponding stock turnover of A shares.
REMOTE	Calls a function on a remote server.

Date

Function	Description
TIME	Converts a provided hour, minute, and second into a time.
TIMEVALUE	Returns the fraction of a 24-hour day the time represents.
EOMONTH	Returns a date on the last day of a month that falls a specified number of months before or after another date.
EDATE	Returns a date a specified number of months before or after another date.
SECOND	Returns the second component of a specific time, in numeric format.
MINUTE	Returns the minute component of a specific time, in numeric format.
HOUR	Returns the hour component of a specific time, in numeric format.
NOW	Returns the current date and time as a date value.
NETWORKDAYS	Returns the number of net working days between two provided days.
NETWORKDAYS_INTL	Returns the number of net working days between two provided days excluding specified weekend days and holidays.
ISOWEEKNUM	Returns a number representing the ISO week of the year where the provided date falls.
WEEKNUM	Returns a number representing the week of the year where the provided date falls.
WEEKDAY	Returns a number representing the day of the week of the date provided.
DAY	Returns the day of the month that a specific date falls on, in numeric format.
DAYS	Returns the number of days between two dates.
DAYS360	Returns the difference between two days based on the 360 day year used in some financial interest calculations.
DATE	Converts a provided year, month, and day into a date.
DATEVALUE	Converts a provided date string in a known format to a date value.
DATEDIF	Calculates the number of days, months, or years between two dates.
WORKDAY	Calculates the date after a number of working days from a specified start date.
WORKDAY_INTL	Calculates the date after a specified number of workdays excluding specified weekend days and holidays.
YEAR	Returns the year specified by a given date.
YEARFRAC	Returns the number of years, including fractional years, between two dates using a specified day count convention.
TODAY	Returns the current date as a date value.
MONTH	Returns the month of the year a specific date falls in, in numeric format.
ISDATE	Returns whether a value is a date.

Engineering

Function	Description
ERFC	Returns the complementary Gauss error function of a value.
BIN2DEC	Converts a signed binary number to decimal format.
BIN2HEX	Converts a signed binary number to signed hexadecimal format.
BIN2OCT	Converts a signed binary number to signed octal format.
DEC2BIN	Converts a decimal number to signed binary format.
DEC2HEX	Converts a decimal number to signed hexadecimal format.
DEC2OCT	Converts a decimal number to signed octal format.
HEX2BIN	Converts a signed hexadecimal number to signed binary format.
HEX2DEC	Converts a signed hexadecimal number to decimal format.
HEX2OCT	Converts a signed hexadecimal number to signed octal format.
OCT2BIN	Converts a signed octal number to signed binary format.
OCT2DEC	Converts a signed octal number to decimal format.
OCT2HEX	Converts a signed octal number to signed hexadecimal format.
COMPLEX	Creates a complex number given real and imaginary coefficients.
IMREAL	Returns the real coefficient of a complex number.
IMAGINARY	Returns the imaginary coefficient of a complex number.
IMCONJUGATE	Returns the complex conjugate of a number.
IMABS	Returns absolute value (or modulus) of a complex number.
DELTA	Compare two numeric values, returning 1 if they're equal.
IMSUM	Returns the sum of a series of complex numbers.
IMSUB	Returns the difference between two complex numbers.
IMPRODUCT	Returns the result of multiplying a series of complex numbers together.
IMDIV	Returns one complex number divided by another.

Financial

Function	Description
EFFECT	Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.
DOLLARDE	Converts a price quotation given as a decimal fraction into a decimal value.
DOLLARFR	Converts a price quotation given as a decimal value into a decimal fraction.
DB	Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
DDB	Calculates the depreciation of an asset for a specified period using the double-declining balance method.
RATE	Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.
CUMPRINC	Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
COUPNUM	Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.
SYD	Calculates the depreciation of an asset for a specified period using the sum of years digits method.
TBILLEQ	Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.
TBILLYIELD	Calculates the yield of a US Treasury Bill based on price.
TBILLPRICE	Calculates the price of a US Treasury Bill based on discount rate.
PV	Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
ACCRINT	Calculates the accrued interest of a security that has periodic payments.
ACCRINTM	Calculates the accrued interest of a security that pays interest at maturity.
COUPDAYBS	Calculates the number of days from the first coupon, or interest payment, until settlement.
COUPDAYS	Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.
COUPDAYSNC	Calculates the number of days from the settlement date until the next coupon, or interest payment.
COUPNCD	Calculates next coupon, or interest payment, date after the settlement date.
COUPPCD	Calculates last coupon, or interest payment, date before the settlement date.
FV	Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
FVSCHEDULE	Calculates the future value of some principal based on a specified series of potentially varying interest rates.
YIELD	Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.
YIELDDISC	Calculates the annual yield of a discount (non-interest-bearing) security, based on price.
NOMINAL	Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.
XIRR	Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.
MIRR	Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income.
IRR	Calculates the internal rate of return on an investment based on a series of periodic cash flows.
NPV	Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.
XNPV	Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate.
CUMIPMT	Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
PMT	Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.
IPMT	Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.
PPMT	Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.
INTRATE	Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself.
PRICE	Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.
PRICEDISC	Calculates the price of a discount (non-interest-bearing) security, based on expected yield.
PRICEMAT	Calculates the price of a security paying interest at maturity, based on expected yield.
RECEIVED	Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.
DISC	Calculates the discount rate of a security based on price.
NPER	Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
SLN	Calculates the depreciation of an asset for one period using the straight-line method.
DURATION	Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value.
MDURATION	Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.

Logical

Function	Description
NOT	Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
TRUE	Returns the logical value `TRUE`.
FALSE	Returns the logical value `FALSE`.
AND	Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.
IFERROR	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.
IF	Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
OR	Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.

Lookup

Function	Description
VLOOKUP	Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.
HLOOKUP	Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found.
LOOKUP	Looks through a sorted row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.
ADDRESS	Returns a cell reference as a string.
INDIRECT	Returns a cell reference specified by a string.
ROW	Returns the row number of a specified cell.
ROWS	Returns the number of rows in a specified array or range.
COLUMN	Returns the column number of a specified cell, with `A=1`.
COLUMNS	Returns the number of columns in a specified array or range.
OFFSET	Returns a range reference shifted a specified number of rows and columns from a starting cell reference.
MATCH	Returns the relative position of an item in a range that matches a specified value.
INDEX	Returns the content of a cell, specified by row and column offset.
GETPIVOTDATA	Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.
CHOOSE	Returns an element from a list of choices based on index.
HYPERLINK	Creates a hyperlink inside a cell.

Luckysheet

Function	Description
AGE_BY_IDCARD	Calculate the age based on the Chinese ID number.
SEX_BY_IDCARD	Calculate gender based on Chinese ID number.
BIRTHDAY_BY_IDCARD	Calculate the birthday based on the Chinese ID number.
PROVINCE_BY_IDCARD	Calculate the province of birthplace based on the Chinese ID number.
CITY_BY_IDCARD	Calculate the city of birthplace based on the Chinese ID number.
STAR_BY_IDCARD	Calculate the constellation based on the Chinese ID number.
ANIMAL_BY_IDCARD	Calculate the zodiac (rat, ox, tiger, rabbit...) based on the Chinese ID number.
ISIDCARD	Verify that the format of the ID card is correct.
LINESPLINES	Generate sparklines embedded in the cell to describe the continuous trend of data
AREASPLINES	Generate sparklines embedded in the cell area chart, generally used to describe the continuous cumulative value trend of the data.
COLUMNSPLINES	Generate sparklines embedded in the vertical histogram of cells, generally used to describe the size of discrete data.
STACKCOLUMNSPLINES	Generate sparklines, a cumulative vertical histogram embedded in a cell, generally used to describe the numerical size of multiple dimensions of discrete data.
BARSPLINES	Generate sparklines embedded in the cell, generally used to describe the size of discrete data.
STACKBARSPLINES	Generate sparklines, a cumulative horizontal bar graph embedded in a cell, which is generally used to describe the numerical size of multiple dimensions of discrete data.
DISCRETESPLINES	Generate sparklines embedded in the cell, generally used to describe the trend of discrete data.
TRISTATESPLINES	Generate sparklines, a three-state graph embedded in the cell, which is generally used to describe the trend of three situations, such as winning, losing, or drawing.
PIESPLINES	Generate sparklines pie chart embedded in the cell, generally used to describe the proportion of data.
BOXSPLINES	Generate sparklines embedded in the cell box plot, generally used to describe the statistical distribution of the data set.
BULLETSPLINES	Generate sparklines embedded in the cell, generally used to describe the task achievement rate.
COMPOSESPLINES	Support multiple types of pictures in the same cell, each parameter represents a sparklines diagram.
EVALUATE	Evaluate a formula or expression expressed in words and return the result.

Math

Function	Description
SUMIF	Returns a conditional sum across a range.
TAN	Returns the tangent of an angle provided in radians.
TANH	Returns the hyperbolic tangent of any real number.
CEILING	Rounds a number up to the nearest integer multiple of specified significance `factor`.
ATAN	Returns the inverse tangent of a value, in radians.
ASINH	Returns the inverse hyperbolic sine of a number.
ABS	Returns the absolute value of a number.
ACOS	Returns the inverse cosine of a value, in radians.
ACOSH	Returns the inverse hyperbolic cosine of a number.
MULTINOMIAL	Returns the factorial of the sum of values divided by the product of the values' factorials.
ATANH	Returns the inverse hyperbolic tangent of a number.
ATAN2	Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians.
COSH	Returns the hyperbolic cosine of any real number.
INT	Rounds a number down to the nearest integer that is less than or equal to it.
ISEVEN	Checks whether the provided value is even.
ISODD	Checks whether the provided value is odd.
LCM	Returns the least common multiple of one or more integers.
LN	Returns the logarithm of a number, base e (Euler's number).
LOG	Returns the logarithm of a number with respect to a base.
LOG10	Returns the logarithm of a number, base 10.
MOD	Returns the result of the modulo operator, the remainder after a division operation.
MROUND	Rounds one number to the nearest integer multiple of another.
ODD	Rounds a number up to the nearest odd integer.
SUMSQ	Returns the sum of the squares of a series of numbers and/or cells.
COMBIN	Returns the number of ways to choose some number of objects from a pool of a given size of objects.
SUM	Returns the sum of a series of numbers and/or cells.
SUBTOTAL	Returns a subtotal for a vertical range of cells using a specified aggregation function.
ASIN	Returns the inverse sine of a value, in radians.
RADIANS	Converts an angle value in degrees to radians.
RAND	Returns a random number between 0 inclusive and 1 exclusive.
COUNTUNIQUE	Counts the number of unique values in a list of specified values and ranges.
DEGREES	Converts an angle value in radians to degrees.
EVEN	Rounds a number up to the nearest even integer.
EXP	Returns Euler's number, e (~2.718) raised to a power.
FACT	Returns the factorial of a number.
FACTDOUBLE	Returns the "double factorial" of a number.
PI	Returns the value of Pi to 14 decimal places.
FLOOR	Rounds a number down to the nearest integer multiple of specified significance `factor`.
GCD	Returns the greatest common divisor of one or more integers.
RANDBETWEEN	Returns a uniformly random integer between two values, inclusive.
ROUND	Rounds a number to a certain number of decimal places according to standard rules.
ROUNDDOWN	Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.
ROUNDUP	Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
SERIESSUM	Given parameters `x`, `n`, `m`, and `a`, returns the power series sum a
SIGN	Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
SIN	Returns the sine of an angle provided in radians.
SINH	Returns the hyperbolic sine of any real number.
SQRT	Returns the positive square root of a positive number.
SQRTPI	Returns the positive square root of the product of Pi and the given positive number.
COS	Returns the cosine of an angle provided in radians.
TRUNC	Truncates a number to a certain number of significant digits by omitting less significant digits.
QUOTIENT	Returns one number divided by another.
POWER	Returns a number raised to a power.
SUMIFS	Returns the sum of a range depending on multiple criteria.
PRODUCT	Returns the result of multiplying a series of numbers together.

Operator

Function	Description
NE	Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. 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.
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.
ADD	Returns the sum of two numbers. 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.
DIVIDE	Returns one number divided by another. Equivalent to the `/` operator.
CONCAT	Returns the concatenation of two values. Equivalent to the `&` operator.
UNARY_PERCENT	Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.

Other

Function	Description
ISFORMULA	Checks whether a value is a formula.
CELL	Returns the requested information about the specified cell.
NA	Returns the `#N/A` error.
ERROR_TYPE	Returns a number corresponding to the error value in a different cell.
ISBLANK	Checks whether the referenced cell is empty.
ISERR	Checks whether a value is an error other than `#N/A`.
ISERROR	Checks whether a value is an error.
ISLOGICAL	Checks whether a value is `TRUE` or `FALSE`.
ISNA	Checks whether a value is the error `#N/A`.
ISNONTEXT	Checks whether a value is non-textual.
ISNUMBER	Checks whether a value is a number.
ISREF	Checks whether a value is a valid cell reference.
ISTEXT	Checks whether a value is text.
TYPE	Returns a number associated with the type of data passed into the function.
N	Returns the argument provided as a number. Text is converted to 0 and errors are returned as-is.
TO_DATE	Converts a provided number to a date.
TO_PURE_NUMBER	Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.
TO_TEXT	Converts a provided numeric value to a text value.
TO_DOLLARS	Converts a provided number to a dollar value.
TO_PERCENT	Converts a provided number to a percentage.
DGET	Returns a single value from a database table-like array or range using a SQL-like query.
DMAX	Returns the maximum value selected from a database table-like array or range using a SQL-like query.
DMIN	Returns the minimum value selected from a database table-like array or range using a SQL-like query.
DAVERAGE	Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.
DCOUNT	Counts numeric values selected from a database table-like array or range using a SQL-like query.
DCOUNTA	Counts values, including text, selected from a database table-like array or range using a SQL-like query.
DPRODUCT	Returns the product of values selected from a database table-like array or range using a SQL-like query.
DSTDEV	Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.
DSTDEVP	Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.
DSUM	Returns the sum of values selected from a database table-like array or range using a SQL-like query.
DVAR	Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.
DVARP	Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.

Parser

Function	Description
CONVERT	Converts a numeric value to a different unit of measure.

Statistical

Function	Description
COUNTBLANK	Returns the number of empty values in a list of values and ranges.
COUNTIF	Returns a conditional count across a range.
GAMMALN	Returns the logarithm of a specified Gamma function, base e (Euler's number).
COUNTIFS	Returns the count of a range depending on multiple criteria.
HARMEAN	Calculates the harmonic mean of a dataset.
HYPGEOMDIST	Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.
INTERCEPT	Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).
KURT	Calculates a Kurtosis of a dataset.
LARGE	Returns the nth largest element from a data set, where n is user-defined.
STDEVA	Calculates the standard deviation based on a sample, setting text to the value `0`.
STDEVP	Calculates the standard deviation based on an entire population.
GEOMEAN	Calculates the geometric mean of a dataset.
RANK_EQ	Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned.
RANK_AVG	Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned.
PERCENTRANK_EXC	Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.
PERCENTRANK_INC	Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.
FORECAST	Calculates the expected y-value for a specified x based on a linear regression of a dataset.
FISHERINV	Returns the inverse Fisher transformation of a specified value.
FISHER	Returns the Fisher transformation of a specified value.
MODE_SNGL	Returns the most commonly occurring value in a dataset.
WEIBULL_DIST	Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.
COUNT	Returns the number of numeric values in a dataset.
COUNTA	Returns the number of values in a dataset.
AVEDEV	Calculates the average of the magnitudes of deviations of data from a dataset's mean.
AVERAGE	Returns the numerical average value in a dataset, ignoring text.
AVERAGEA	Returns the numerical average value in a dataset.
BINOM_DIST	Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.
BINOM_INV	Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.
CONFIDENCE_NORM	Calculates the width of half the confidence interval for a normal distribution.
CORREL	Calculates r, the Pearson product-moment correlation coefficient of a dataset.
COVARIANCE_P	Calculates the covariance of a dataset.
COVARIANCE_S	Calculates the sample covariance of a dataset.
DEVSQ	Calculates the sum of squares of deviations based on a sample.
EXPON_DIST	Returns the value of the exponential distribution function with a specified lambda at a specified value.
AVERAGEIF	Returns the average of a range depending on criteria.
AVERAGEIFS	Returns the average of a range depending on multiple criteria.
PERMUT	Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.
TRIMMEAN	Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.
PERCENTILE_EXC	Returns the value at a given percentile of a dataset exclusive of 0 and 1.
PERCENTILE_INC	Returns the value at a given percentile of a dataset.
PEARSON	Calculates r, the Pearson product-moment correlation coefficient of a dataset.
NORM_S_INV	Returns the value of the inverse standard normal distribution function for a specified value.
NORM_S_DIST	Returns the value of the standard normal cumulative distribution function for a specified value.
NORM_INV	Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.
NORM_DIST	Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
NEGBINOM_DIST	Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.
MINA	Returns the minimum numeric value in a dataset.
MIN	Returns the minimum value in a numeric dataset.
MEDIAN	Returns the median value in a numeric dataset.
MAXA	Returns the maximum numeric value in a dataset.
MAX	Returns the maximum value in a numeric dataset.
LOGNORM_INV	Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value.
LOGNORM_DIST	Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.
Z_TEST	Returns the one-tailed p-value of a Z-test with standard distribution.
PROB	Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.
QUARTILE_EXC	Returns a value nearest to a specified quartile of a dataset exclusive of 0 and 4.
QUARTILE_INC	Returns a value nearest to a specified quartile of a dataset.
POISSON_DIST	Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.
RSQ	Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.
T_DIST	Calculates the left tail probability for a Student's t-distribution with a given input (x).
T_DIST_2T	Calculates the probability for two tailed Student's t-distribution with a given input (x).
T_DIST_RT	Calculates the right tail probability for a Student's t-distribution with a given input (x).
T_INV	Calculates the negative inverse of the one-tailed TDIST function.
T_INV_2T	Calculates the inverse of the two-tailed TDIST function.
T_TEST	t-test. Returns the probability associated with Student's t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean.
F_DIST	Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution.
F_DIST_RT	Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution.
VAR_P	Calculates the variance based on an entire population.
VAR_S	Calculates the variance based on a sample.
VARA	Calculates the variance based on a sample, setting text to the value `0`.
VARPA	Calculates the variance based on an entire population, setting text to the value `0`.
STEYX	Calculates the standard error of the predicted y-value for each x in the regression of a dataset.
STANDARDIZE	Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.
SMALL	Returns the nth smallest element from a data set, where n is user-defined.
SLOPE	Calculates the slope of the line resulting from linear regression of a dataset.
SKEW	Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.
SKEW_P	Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean. This assumes the dataset is for the population.

Text

Function	Description
DOLLAR	Formats a number into the currency specific to your spreadsheet locale.
CONCATENATE	Appends strings to one another.
CODE	Returns the numeric Unicode map value of the first character in the string provided.
CHAR	Convert a number into a character according to the current Unicode table.
ARABIC	Computes the value of a Roman numeral.
ROMAN	Formats a number in Roman numerals.
REGEXEXTRACT	Extracts matching substrings according to a regular expression.
REGEXMATCH	Whether a piece of text matches a regular expression.
REGEXREPLACE	Replaces part of a text string with a different text string using regular expressions.
T	Returns string arguments as text, or the empty string if the value is not text.
FIXED	Formats a number with a fixed number of decimal places.
FIND	Returns the position at which a string is first found within text where the capitalization of letters matters. Returns `#VALUE!` if the string is not found.
FINDB	Returns the position at which a string is first found within text counting each double-character as 2.
JOIN	Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
LEFT	Returns a substring from the beginning of a specified string.
RIGHT	Returns a substring from the end of a specified string.
MID	Returns a segment of a string.
LEN	Returns the length of a string.
LENB	Returns the length of a string in bytes.
LOWER	Converts a specified string to lowercase.
UPPER	Converts a specified string to uppercase.
EXACT	Tests whether two strings are identical.
REPLACE	Replaces part of a text string with a different text string.
REPT	Returns specified text repeated a number of times.
SEARCH	Returns the position at which a string is first found within text and ignores capitalization of letters. Returns `#VALUE!` if the string is not found.
SUBSTITUTE	Replaces existing text with new text in a string.
CLEAN	Returns the text with the non-printable ASCII characters removed.
TEXT	Converts a number into text according to a specified format.
TRIM	Removes leading, trailing, and repeated spaces in text.
VALUE	Converts a string in any of the date, time or number formats that Google Sheets understands into a number.
PROPER	Capitalizes each word in a specified string.