552 spreadsheet functions — deepcalc function reference

functions

every function the deepcalc engine exposes, generated from the engine's own catalog — the signature on these pages is the signature the engine runs.

array 29 database 12 datetime 25 engineering 55 financial 55 information 21 logical 11 lookup 13 math 84 options 20 stats 146 text 59 utility 20 web 2

popular XLOOKUP ·VLOOKUP ·SUMIFS ·INDEX ·MATCH ·IF ·TEXTJOIN ·XNPV

function	what it does	category
ABS	returns absolute value of a number	math
ACCRINT	accrued interest for a security paying periodic interest	financial
ACCRINTM	accrued interest for a security paying at maturity	financial
ACOS	returns arccosine of a number	math
ACOSH	returns inverse hyperbolic cosine	math
ACOT	returns the arccotangent of a number	math
ACOTH	returns the inverse hyperbolic cotangent	math
ADDRESS	returns a cell address as text from row and column numbers	lookup
AMORDEGRC	depreciation per period, French accounting, degressive	financial
AMORLINC	depreciation per period, French accounting, linear	financial
AND	returns TRUE if all arguments are true	logical
ARABIC	converts roman numeral to arabic number	math
AREAS	returns the number of areas in a reference	lookup
ARRAYTOTEXT	converts array to text representation	array
ASC	converts full-width characters to half-width	text
ASIAN.CALL	Asian call on the geometric average of n_avg observations (exact closed form; approximates the arithmetic Asian)	options
ASIN	returns arcsine of a number	math
ASINH	returns inverse hyperbolic sine	math
ATAN	returns arctangent of a number	math
ATAN2	returns arctangent from x and y coordinates	math
ATANH	returns inverse hyperbolic tangent	math
AVEDEV	average of absolute deviations from the mean	stats
AVERAGE	calculates arithmetic mean	math
AVERAGEA	averages values including text and logicals	stats
AVERAGEIF	averages cells that match a condition	stats
AVERAGEIFS	averages cells matching multiple conditions	stats
BARRIER.CALL	barrier call option: type 1=down-and-out, 2=down-and-in, 3=up-and-out, 4=up-and-in (Hull ch. 26 formulas)	options
BASE	converts number to text in given base	math
BESSELI	returns modified Bessel function In(x)	engineering
BESSELJ	returns Bessel function Jn(x)	engineering
BESSELK	returns modified Bessel function Kn(x)	engineering
BESSELY	returns Bessel function Yn(x)	engineering
BETA.DIST	beta distribution	stats
BETA.INV	inverse of the beta distribution	stats
BETADIST	legacy form of BETA.DIST (cumulative)	stats
BETAINV	legacy form of BETA.INV	stats
BIN2DEC	converts binary number to decimal	engineering
BIN2HEX	converts binary number to hexadecimal	engineering
BIN2OCT	converts binary number to octal	engineering
BINOM.DIST	binomial distribution probability	stats
BINOM.DIST.RANGE	probability of a trial result range	stats
BINOM.INV	smallest value with cumulative binomial at or above a criterion	stats
BINOMDIST	legacy form of BINOM.DIST	stats
BINOMIAL.AMERICAN.PUT	binomial tree American put option price	options
BINOMIAL.CALL	binomial tree call option price	options
BINOMIAL.PUT	binomial tree put option price	options
BITAND	returns bitwise AND of two numbers	engineering
BITLSHIFT	returns number shifted left by bits	engineering
BITOR	returns bitwise OR of two numbers	engineering
BITRSHIFT	returns number shifted right by bits	engineering
BITXOR	returns bitwise XOR of two numbers	engineering
BS.CALL	Black-Scholes call option price	options
BS.CALL.DIVIDEND	Black-Scholes call option with dividend yield	options
BS.IMPLIED_VOL.CALL	implied volatility from call option price	options
BS.IMPLIED_VOL.PUT	implied volatility from put option price	options
BS.PUT	Black-Scholes put option price	options
BS.PUT.DIVIDEND	Black-Scholes put option with dividend yield	options
BYCOL	applies lambda to each column of array	array
BYROW	applies lambda to each row of array	array
CEILING	rounds up to the nearest multiple of significance	math
CEILING.MATH	rounds up with optional significance and mode	math
CEILING.PRECISE	rounds up to the nearest multiple, sign-independent	math
CELL	information about a cell's formatting, location or contents	information
CHAR	returns the character for a character-set code	text
CHIDIST	legacy form of CHISQ.DIST.RT	stats
CHIINV	legacy form of CHISQ.INV.RT	stats
CHISQ.DIST	returns the chi-squared distribution	stats
CHISQ.DIST.RT	returns the right-tailed chi-squared distribution	stats
CHISQ.INV	returns the inverse of the chi-squared distribution	stats
CHISQ.INV.RT	returns the inverse of the right-tailed chi-squared distribution	stats
CHISQ.TEST	chi-squared test for independence	stats
CHITEST	legacy form of CHISQ.TEST	stats
CHOOSE	chooses a value from a list by index	math
CHOOSECOLS	returns the specified columns from an array	array
CHOOSEROWS	returns the specified rows from an array	array
CLEAN	removes non-printable characters	text
CODE	numeric code of the first character	text
COLUMN	returns column number of a reference	math
COLUMNS	returns number of columns in a reference	math
COMBIN	number of combinations of n items taken k at a time	math
COMBINA	combinations with repetitions	math
COMPLEX	converts real and imaginary to complex	engineering
CONCAT	joins multiple text strings into one	text
CONCATENATE	joins several text strings into one	text
CONFIDENCE	legacy form of CONFIDENCE.NORM	stats
CONFIDENCE.NORM	confidence interval for a population mean, normal	stats
CONFIDENCE.T	confidence interval for a population mean, Student's t	stats
CONTAINS	checks if text contains substring	text
CONVERT	converts number between measurement units	engineering
CORREL	correlation coefficient between two data sets	stats
COS	returns cosine of an angle	math
COSH	returns hyperbolic cosine	math
COT	returns cotangent of an angle	math
COTH	returns hyperbolic cotangent	math
COUNT	counts cells containing numbers	stats
COUNTA	counts non-empty cells in a range	stats
COUNTBLANK	counts empty cells in a range	stats
COUNTIF	counts cells that match a condition	stats
COUNTIFS	counts cells matching multiple conditions	stats
COUPDAYBS	days from coupon period start to settlement	financial
COUPDAYS	days in the coupon period containing settlement	financial
COUPDAYSNC	days from settlement to the next coupon date	financial
COUPNCD	next coupon date after settlement	financial
COUPNUM	number of coupons between settlement and maturity	financial
COUPPCD	previous coupon date before settlement	financial
COVAR	legacy form of COVARIANCE.P: population covariance	stats
COVARIANCE.P	population covariance	stats
COVARIANCE.S	sample covariance	stats
CRITBINOM	legacy form of BINOM.INV	stats
CSC	returns cosecant of an angle	math
CSCH	returns hyperbolic cosecant	math
CUMIPMT	returns cumulative interest paid on loan	financial
CUMPRINC	returns cumulative principal paid on loan	financial
DATE	creates date from year, month, day	datetime
DATEDIF	calculates difference between two dates	datetime
DATEVALUE	converts date text to serial number	datetime
DAVERAGE	average of database values matching criteria	database
DAY	returns day of month from date	datetime
DAYS	returns number of days between two dates	datetime
DAYS360	returns days between dates on 360-day year	datetime
DB	returns fixed-declining balance depreciation	financial
DCOUNT	counts numeric database values matching criteria	database
DCOUNTA	counts non-empty database values matching criteria	database
DDB	returns double-declining balance depreciation	financial
DEC2BIN	converts decimal number to binary	engineering
DEC2HEX	converts decimal number to hexadecimal	engineering
DEC2OCT	converts decimal number to octal	engineering
DECIMAL	converts text in given base to number	math
DECODEURL	decodes URL-encoded text	web
DEGREES	converts radians to degrees	math
DELTA	tests if two values are equal	engineering
DELTA.CALL	delta of call option (rate of change with respect to underlying price)	options
DELTA.PUT	delta of put option	options
DEVSQ	sum of squared deviations from the mean	stats
DGET	the single database value matching criteria	database
DIGITAL.CALL	digital (binary) call option that pays fixed amount	options
DISC	discount rate of a security	financial
DMAX	largest database value matching criteria	database
DMIN	smallest database value matching criteria	database
DOLLAR	formats a number as currency text	text
DOLLARDE	converts fractional dollar to decimal	financial
DOLLARFR	converts decimal dollar to fractional	financial
DPRODUCT	product of database values matching criteria	database
DROP	removes rows or columns from the start or end of an array	array
DSTDEV	sample standard deviation of matching database values	database
DSTDEVP	population standard deviation of matching database values	database
DSUM	sum of database values matching criteria	database
DURATION	returns the Macaulay duration of a security	financial
DVAR	sample variance of matching database values	database
DVARP	population variance of matching database values	database
EDATE	returns date shifted by given months	datetime
EFFECT	returns effective annual interest rate	financial
ENCODEURL	encodes text for use in URLs using percent encoding	web
ENDSWITH	checks if text ends with suffix	text
EOMONTH	returns last day of month after offset	datetime
ERF	returns the error function	engineering
ERF.PRECISE	returns the error function integrated from 0	engineering
ERFC	returns complementary error function	engineering
ERFC.PRECISE	returns complementary error function from x	engineering
ERROR.TYPE	returns number corresponding to an error type	information
EVEN	rounds up to the nearest even integer	math
EXACT	checks if two text strings are identical	text
EXP	e raised to the power of a number	math
EXPAND	pads an array to a given size with a fill value	array
EXPON.DIST	exponential distribution	stats
EXPONDIST	legacy form of EXPON.DIST	stats
F.DIST	F probability distribution	stats
F.DIST.RT	right-tailed F probability distribution	stats
F.INV	inverse of the F distribution	stats
F.INV.RT	inverse of the right-tailed F distribution	stats
F.TEST	F-test for equality of variances	stats
FACT	factorial of a number	math
FACTDOUBLE	returns double factorial of a number	math
FALSE	returns the logical value FALSE	logical
FDIST	legacy form of F.DIST.RT	stats
FILTER	returns the rows or columns of a range that meet a condition	array
FIND	finds text within another text, case-sensitive	text
FINDB	finds text within text by bytes, case-sensitive	text
FINV	legacy form of F.INV.RT	stats
FISHER	returns the Fisher transformation	stats
FISHERINV	inverse of the Fisher transformation	stats
FIXED	formats a number as text with a fixed number of decimals	text
FLOOR	rounds down to the nearest multiple of significance	math
FLOOR.MATH	rounds down with optional significance and mode	math
FLOOR.PRECISE	rounds down to the nearest multiple, sign-independent	math
FORECAST	predicts a value along a linear trend	stats
FORECAST.ETS	forecasts a value using exponential smoothing	stats
FORECAST.ETS.CONFINT	confidence interval for an ETS forecast	stats
FORECAST.ETS.SEASONALITY	season length detected by ETS	stats
FORECAST.ETS.STAT	statistic from the ETS model	stats
FORECAST.LINEAR	predicts a value on the linear regression line	stats
FORMULATEXT	returns formula as a text string	information
FREQUENCY	counts values falling into bins, spilled as a column	stats
FROMBYTES	converts byte array to integer	utility
FTEST	legacy form of F.TEST	stats
FV	returns future value of an investment	financial
FVSCHEDULE	future value under a schedule of compound rates	financial
GAMMA	returns the gamma function value	math
GAMMA.DIST	gamma distribution	stats
GAMMA.INV	inverse of the gamma distribution	stats
GAMMADIST	legacy form of GAMMA.DIST	stats
GAMMAINV	legacy form of GAMMA.INV	stats
GAMMALN	natural logarithm of the gamma function	stats
GAMMALN.PRECISE	natural logarithm of the gamma function	stats
GAUSS	probability a standard normal member falls between the mean and z	stats
GCD	greatest common divisor	math
GENERATEID	generates unique ID with prefix and random suffix	utility
GEOMEAN	returns geometric mean of positive values	stats
GESTEP	tests if number is greater than threshold	engineering
GROWTH	values along an exponential trend	stats
HARMEAN	returns the harmonic mean	stats
HASH	hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321)	utility
HEX2BIN	converts hexadecimal number to binary	engineering
HEX2DEC	converts hexadecimal number to decimal	engineering
HEX2OCT	converts hexadecimal number to octal	engineering
HLOOKUP	searches first row and returns matching value	lookup
HOUR	returns hour component of a time	datetime
HSTACK	joins arrays side by side into one array	array
HYPGEOM.DIST	hypergeometric distribution	stats
HYPGEOMDIST	legacy form of HYPGEOM.DIST	stats
IF	returns one value if condition is true, another if false	logical
IFERROR	returns value if no error, otherwise alternate	logical
IFNA	returns value if not #N/A, otherwise alternate	logical
IFS	checks multiple conditions, returns first match	logical
IMABS	returns absolute value of complex number	engineering
IMAGINARY	returns imaginary coefficient of complex number	engineering
IMARGUMENT	returns argument theta of complex number	engineering
IMCONJUGATE	returns complex conjugate of complex number	engineering
IMCOS	returns cosine of a complex number	engineering
IMCOSH	returns hyperbolic cosine of complex number	engineering
IMCOT	returns cotangent of a complex number	engineering
IMCSC	returns cosecant of a complex number	engineering
IMCSCH	returns hyperbolic cosecant of complex number	engineering
IMDIV	returns quotient of two complex numbers	engineering
IMEXP	returns exponential of a complex number	engineering
IMLN	returns natural logarithm of complex number	engineering
IMLOG10	returns base-10 logarithm of complex number	engineering
IMLOG2	returns base-2 logarithm of complex number	engineering
IMPOWER	returns complex number raised to power	engineering
IMPRODUCT	returns product of complex numbers	engineering
IMREAL	returns real coefficient of complex number	engineering
IMSEC	returns secant of a complex number	engineering
IMSECH	returns hyperbolic secant of complex number	engineering
IMSIN	returns sine of a complex number	engineering
IMSINH	returns hyperbolic sine of complex number	engineering
IMSQRT	returns square root of complex number	engineering
IMSUB	returns difference of two complex numbers	engineering
IMSUM	returns sum of complex numbers	engineering
IMTAN	returns tangent of a complex number	engineering
INDEX	returns value at row and column in range	lookup
INDIRECT	returns reference specified by text string	lookup
INFO	information about the operating environment	information
INT	rounds down to the nearest integer	math
INTERCEPT	y-intercept of the linear regression line	stats
INTRATE	interest rate of a fully invested security	financial
IPMT	returns interest payment for a period	financial
IRR	calculates internal rate of return	financial
ISBLANK	returns TRUE if value is blank	information
ISERR	returns TRUE if value is any error except #N/A	information
ISERROR	returns TRUE if value is any error	information
ISEVEN	returns TRUE if number is even	information
ISFORMULA	returns TRUE if cell contains a formula	information
ISIN	checks if value is in a range or comma-separated list	utility
ISLOGICAL	returns TRUE if value is logical	information
ISNA	returns TRUE if value is #N/A error	information
ISNONTEXT	returns TRUE if value is not text	information
ISNUMBER	returns TRUE if value is a number	information
ISO.CEILING	rounds up to the nearest multiple, sign-independent	math
ISODD	returns TRUE if number is odd	information
ISOMITTED	checks if lambda argument is omitted	array
ISOWEEKNUM	returns ISO week number of a date	datetime
ISPMT	returns interest for even-principal payment	financial
ISREF	returns TRUE if value is a reference	information
ISTEXT	returns TRUE if value is text	information
JOIN	joins values with delimiter	text
KURT	returns the kurtosis of a data set	stats
LAMBDA	creates a custom reusable function	array
LARGE	returns the k-th largest value in a data set	stats
LCM	least common multiple	math
LEFT	returns leftmost characters from text	text
LEFTB	returns leftmost bytes from text	text
LEN	returns number of characters in text	text
LENB	returns number of bytes in text	text
LET	assigns names to values in a formula	array
LINEST	parameters of the least-squares linear fit	stats
LN	natural logarithm of a number	math
LOG	logarithm to a given base	math
LOG10	base-10 logarithm of a number	math
LOGEST	parameters of the exponential curve fit	stats
LOGINV	legacy form of LOGNORM.INV	stats
LOGNORM.DIST	lognormal distribution	stats
LOGNORM.INV	inverse of the lognormal distribution	stats
LOGNORMDIST	legacy form of LOGNORM.DIST (cumulative)	stats
LOOKUP	looks up value in one-row or one-column range	lookup
LOWER	converts text to lowercase	text
MAKEARRAY	creates array from lambda over indices	array
MAP	maps lambda over array values	array
MATCH	returns position of value in a range	lookup
MAX	returns the largest value in a set	math
MAXA	returns the largest value, counting text and logicals	stats
MAXIFS	returns largest value matching conditions	stats
MDETERM	returns matrix determinant of an array	math
MDURATION	modified Macauley duration	financial
MEDIAN	returns the median of a set of numbers	stats
MID	returns characters from middle of text	text
MIDB	returns bytes from middle of text	text
MIN	returns the smallest value in a set	math
MINA	returns the smallest value, counting text and logicals	stats
MINIFS	returns smallest value matching conditions	stats
MINUTE	returns minute component of a time	datetime
MINVERSE	returns matrix inverse of an array	math
MIRR	returns modified internal rate of return	financial
MMULT	returns the matrix product of two arrays	math
MOD	remainder after division	math
MODE	legacy form of MODE.SNGL: most frequent value in a data set	stats
MODE.MULT	returns an array of the most frequently occurring values	stats
MODE.SNGL	returns the most frequently occurring value	stats
MONTH	returns month component of a date	datetime
MROUND	rounds to the nearest multiple	math
MULTINOMIAL	returns the multinomial coefficient of a set of numbers	math
MUNIT	returns identity matrix of given size	math
N	converts a value to a number	information
NA	returns the error value #N/A	information
NEGBINOM.DIST	negative binomial distribution	stats
NEGBINOMDIST	legacy form of NEGBINOM.DIST	stats
NETWORKDAYS	returns business days between two dates	datetime
NETWORKDAYS.INTL	counts business days with custom weekend	datetime
NOMINAL	returns annual nominal interest rate	financial
NORM.DIST	normal distribution	stats
NORM.INV	inverse of the normal distribution	stats
NORM.S.DIST	standard normal distribution	stats
NORM.S.INV	inverse of the standard normal distribution	stats
NORMDIST	legacy form of NORM.DIST	stats
NORMINV	legacy form of NORM.INV	stats
NORMSDIST	legacy form of NORM.S.DIST (cumulative)	stats
NORMSINV	legacy form of NORM.S.INV	stats
NOT	reverses the logic of its argument	logical
NOW	returns current date and time	datetime
NPER	returns number of periods for investment	financial
NPV	calculates net present value of investment	financial
NUMBERVALUE	converts text to a number, locale-independent	text
OCT2BIN	converts octal number to binary	engineering
OCT2DEC	converts octal number to decimal	engineering
OCT2HEX	converts octal number to hexadecimal	engineering
ODD	rounds up to the nearest odd integer	math
ODDFPRICE	returns the price of a security with an odd first period	financial
ODDFYIELD	yield of a security with an odd first period	financial
ODDLPRICE	price of a security with an odd last period	financial
ODDLYIELD	yield of a security with an odd last period	financial
OFFSET	returns reference offset from starting point	lookup
OPT.GAMMA	gamma of option (rate of change of delta)	options
OPT.VEGA	vega of option (sensitivity to volatility)	options
OR	returns TRUE if any argument is true	logical
PDURATION	returns periods to reach target value	financial
PEARSON	Pearson product moment correlation coefficient	stats
PERCENTILE	legacy form of PERCENTILE.INC: k-th percentile	stats
PERCENTILE.EXC	k-th percentile, exclusive	stats
PERCENTILE.INC	returns the k-th percentile, inclusive	stats
PERCENTOF	share of a data subset within a whole	stats
PERCENTRANK	legacy form of PERCENTRANK.INC: rank as a percentage	stats
PERCENTRANK.EXC	percentage rank, exclusive	stats
PERCENTRANK.INC	percentage rank, inclusive	stats
PERMUT	returns the number of permutations of a set of objects	stats
PERMUTATIONA	returns the number of permutations with repetitions allowed	stats
PHI	density function value for the standard normal distribution	stats
PI	returns the value of pi	math
PMT	returns periodic payment for an annuity	financial
POISSON	legacy form of POISSON.DIST	stats
POISSON.DIST	Poisson distribution	stats
POWER	returns number raised to a power	math
PPMT	returns principal payment for a period	financial
PRICE	returns the price per $100 face value of a security paying periodic interest	financial
PRICEDISC	price of a discounted security	financial
PRICEMAT	price of a security paying interest at maturity	financial
PROB	probability that values fall within limits	stats
PRODUCT	multiplies all numbers given as arguments	math
PROPER	capitalizes the first letter of each word	text
PV	returns present value of an investment	financial
QUARTILE	legacy form of QUARTILE.INC: quartile of a data set	stats
QUARTILE.EXC	returns a quartile, excluding the median	stats
QUARTILE.INC	returns a quartile, including the median	stats
QUOTIENT	integer portion of a division	math
RADIANS	converts degrees to radians	math
RAND	returns a random number between 0 and 1	math
RANDARRAY	returns an array of random numbers	array
RANDBETWEEN	returns random integer between two values	math
RANDOMCHOICE	random pick from a range (with replacement); count > 1 spills a column	utility
RANDOMINT.UNIQUE	generates unique random integers in range	utility
RANDOMNORMAL	generates random values from normal distribution	utility
RANK	legacy form of RANK.EQ: rank of a number in a list	stats
RANK.AVG	rank of a number, average rank for ties	stats
RANK.EQ	rank of a number, top rank for ties	stats
RATE	returns interest rate per period	financial
RECEIVED	amount received at maturity for a fully invested security	financial
REDUCE	reduces array to value with lambda	array
REGEXEXTRACT	extracts the first regex match	text
REGEXREPLACE	replaces regex matches with new text	text
REGEXTEST	whether text matches a regular expression	text
REPLACE	replaces characters by position	text
REPLACEB	replaces characters by byte position	text
REPT	repeats text a given number of times	text
RHO.CALL	rho of call option (sensitivity to interest rate)	options
RHO.PUT	rho of put option (sensitivity to interest rate)	options
RIGHT	returns rightmost characters from text	text
RIGHTB	returns rightmost bytes from text	text
ROMAN	converts arabic number to roman numeral	math
ROUND	rounds a number to specified digits	math
ROUNDDOWN	rounds a number down toward zero	math
ROUNDUP	rounds a number up away from zero	math
ROW	returns row number of a reference	lookup
ROWS	returns number of rows in a reference	lookup
RRI	returns equivalent interest rate for growth	financial
RSQ	square of the Pearson correlation coefficient	stats
SCAN	scans array with lambda keeping intermediates	array
SEARCH	finds text within another text, case-insensitive	text
SEARCHB	finds text within text by bytes, case-insensitive	text
SEC	returns secant of an angle	math
SECH	returns hyperbolic secant	math
SECOND	returns second component of a time	datetime
SEQUENCE	generates a sequence of numbers as an array	array
SERIESSUM	returns the sum of a power series	math
SHEET	returns sheet number of a reference	information
SHEETS	number of sheets in a reference	information
SIGN	sign of a number as -1, 0 or 1	math
SIN	returns sine of an angle	math
SINH	returns hyperbolic sine	math
SKEW	returns the skewness of a distribution	stats
SKEW.P	skewness based on the entire population	stats
SLN	returns straight-line depreciation per period	financial
SLOPE	slope of the linear regression line	stats
SMALL	returns the k-th smallest value in a data set	stats
SORT	sorts the contents of a range or array	array
SORTBY	sorts a range or array by values in a corresponding range	array
SPLIT	splits text by delimiter into multiple cells	text
SQRT	returns square root of a number	math
SQRTPI	returns square root of number times pi	math
STANDARDIZE	normalized value from a distribution	stats
STARTSWITH	checks if text starts with prefix	text
STDEV	legacy form of STDEV.S: sample standard deviation	stats
STDEV.P	population standard deviation	stats
STDEV.S	sample standard deviation	stats
STDEVA	sample standard deviation, counting text and logicals	stats
STDEVP	legacy form of STDEV.P: population standard deviation	stats
STDEVPA	population standard deviation, counting text and logicals	stats
STEYX	standard error of the predicted y for each x	stats
SUBSTITUTE	replaces old text with new text	text
SUBTOTAL	returns subtotal using specified function	engineering
SUM	adds numbers together	math
SUMIF	sums cells that match a condition	math
SUMIFS	sums cells that match multiple conditions	math
SUMPRODUCT	returns sum of products of array components	math
SUMSQ	sum of the squares of the arguments	math
SUMX2MY2	sum of the difference of squares of two ranges	math
SUMX2PY2	sum of the sum of squares of two ranges	math
SUMXMY2	sum of squared differences of two ranges	math
SWITCH	evaluates expression against list of values	logical
SYD	returns sum-of-years-digits depreciation	financial
T	returns text if value is text, else empty	text
T.DIST	Student's t-distribution	stats
T.DIST.2T	two-tailed Student's t-distribution	stats
T.DIST.RT	right-tailed Student's t-distribution	stats
T.INV	left-tailed inverse of the t-distribution	stats
T.INV.2T	two-tailed inverse of the t-distribution	stats
T.TEST	probability from Student's t-test	stats
TAKE	returns rows or columns from the start or end of an array	array
TAN	returns tangent of an angle	math
TANH	returns hyperbolic tangent	math
TBILLEQ	returns bond-equivalent yield for treasury bill	financial
TBILLPRICE	returns price per $100 for treasury bill	financial
TBILLYIELD	returns yield for a treasury bill	financial
TDIST	legacy form of T.DIST.RT / T.DIST.2T	stats
TEXT	formats number as text with given format	text
TEXTAFTER	returns text after a delimiter	text
TEXTBEFORE	returns text before a delimiter	text
TEXTCAPITALIZE	capitalizes first letter of text	text
TEXTCENTER	centers text with padding to reach specified length	text
TEXTCOMPARE	compares two texts and returns -1, 0, or 1	text
TEXTCOUNT	counts occurrences of substring in text	text
TEXTINDENT	indents text with specified number of characters	text
TEXTJOIN	joins text with delimiter, ignoring blanks	text
TEXTPADLEFT	pads text on the left with character to reach specified length	text
TEXTPADRIGHT	pads text on the right with character to reach specified length	text
TEXTREVERSE	reverses text	text
TEXTSPLIT	splits text by delimiters into an array	text
TEXTSWAPCASE	swaps uppercase and lowercase letters	text
TEXTTITLE	converts text to title case	text
TEXTWRAP	wraps text at specified width	text
THETA.CALL	theta of call option (time decay)	options
THETA.PUT	theta of put option (time decay)	options
TIME	creates time from hour, minute, second	datetime
TIMESTAMP	current timestamp in milliseconds since epoch	utility
TIMEVALUE	converts time text to serial number	datetime
TINV	legacy form of T.INV.2T	stats
TOARRAY	materializes a range as a dynamic array (spills)	utility
TOBOOL	converts value to boolean	utility
TOCOL	returns an array as a single column	array
TODATE	parses text (YYYY-M-D, YYYY/M/D, M/D/YYYY, D.M.YYYY) to a date serial	utility
TODAY	returns current date	datetime
TONUMBER	converts value to number; unparseable text returns default when given, else #VALUE!	utility
TOROW	returns an array as a single row	array
TOTEXT	converts value to text representation	utility
TOTIME	parses \"HH:MM\" or \"HH:MM:SS\" text to a time fraction of day	utility
TRANSPOSE	flips the orientation of a range or array	array
TREND	values along a linear trend	stats
TRIM	removes extra spaces from text	text
TRIMMEAN	mean of the interior of a data set	stats
TRIMRANGE	trims empty rows and columns from the edges of a range	array
TRUE	returns the logical value TRUE	logical
TRUNC	truncates a number to a given precision	math
TTEST	legacy form of T.TEST	stats
TYPE	returns type of a value as number	information
UNICHAR	returns the character for a unicode code point	text
UNICODE	returns unicode number of first character	text
UNIQUE	returns the distinct values from a range or array	array
UPPER	converts text to uppercase	text
UUID	generates UUID v4 string	utility
VALIDATE.DATE	validates date components form valid date	utility
VALIDATE.EMAIL	validates email address format	utility
VALIDATE.PHONE	validates phone number format	utility
VALIDATE.RANGE	validates value is within min and max range	utility
VALIDATE.URL	validates URL format	utility
VALUE	converts text string to a number	text
VALUETOTEXT	returns text from any value type	text
VAR	legacy form of VAR.S: sample variance	stats
VAR.P	population variance	stats
VAR.S	sample variance	stats
VARA	sample variance, counting text and logicals	stats
VARP	legacy form of VAR.P: population variance	stats
VARPA	population variance, counting text and logicals	stats
VDB	depreciation over a period, declining balance with switch	financial
VLOOKUP	looks up value in first column of range and returns value from specified column	lookup
VSTACK	stacks arrays on top of each other into one array	array
WEEKDAY	returns day of week as a number	datetime
WEEKNUM	returns week number of a date	datetime
WEIBULL	legacy form of WEIBULL.DIST	stats
WEIBULL.DIST	Weibull distribution	stats
WORKDAY	returns date after given business days	datetime
WORKDAY.INTL	adds business days with custom weekend	datetime
WRAPCOLS	wraps a row or column into a 2-D array by columns	array
WRAPROWS	wraps a row or column into a 2-D array by rows	array
XIRR	returns internal rate for irregular cash flows	financial
XLOOKUP	searches range and returns matching item	lookup
XMATCH	returns the position of an item in a range or array	lookup
XNPV	returns net present value for irregular cash flows	financial
XOR	returns exclusive or of all arguments	logical
YEAR	returns year component of a date	datetime
YEARFRAC	returns fraction of year between dates	datetime
YIELD	returns the yield of a security paying periodic interest	financial
YIELDDISC	annual yield of a discounted security	financial
YIELDMAT	annual yield of a security paying interest at maturity	financial
Z.TEST	one-tailed p-value of a z-test	stats
ZTEST	legacy form of Z.TEST	stats