Complete List

ABS The absolute value or a number without its sign.

ACCRINT The accrued interest for a security that pays interest periodically.

ACCRINTM The accrued interest for a security that pays interest at maturity.

ACOS The arc-cosine of a number.

ACOSH The hyperbolic arc-cosine of a number.

ACOT The arc-cotangent of a number.

ACOTH The hyperbolic arc-cotangent of a number.

ADDRESS The cell reference given a row and column number.

AGGREGATE The choice of 19 different operations for numerical values which can ignore hidden rows and errors.

AMORDEGRC The depreciation of an asset in a single period (straight-line, implicit coefficient).

AMORLINC The depreciation of an asset in a single period (straight-line).

AND The boolean True or False depending on multiple conditions.

ARABIC The number converted from roman to arabic.

AREAS The number of areas in a cell range or reference.

ARRAYTOTEXT (2021) New. The contents of an array or cell range converted to text.

ASC (Japanese) The text string converted from double byte to single byte characters.

ASIN The arc-sine of a number.

ASINH The hyperbolic arc-sine of a number.

ATAN The arc-tangent of a number.

ATAN2 The arc-tangent of the specified x and y co-ordinates.

ATANH The hyperbolic arc-tangent of a number.

AVEDEV The average deviation of the numerical values.

AVERAGE The arithmetic mean of the numerical values.

AVERAGEA The arithmetic mean of the numerical values (including logical values and text).

AVERAGEIF (AVERAGEIFS) The arithmetic mean of the numerical values that satisfies one condition.

AVERAGEIFS The arithmetic mean of the numerical values that satisfies multiple conditions.

BAHTTEXT The number converted to a Thai text string and appends 'Baht'.

BASE The number converted into a text representation with the given base.

BESSELI The Bessel function evaluated for purely imaginary arguments.

BESSELJ The modified Bessel function represented by J(x).

BESSELK The modified Bessel function represented by K(x).

BESSELY The modified Bessel function represented by Y(x).

BETA.DIST The probability distribution function OR the cumulative probability function for a beta distribution.

BETA.INV The inverse of the cumulative probability function for a beta distribution.

BETADIST (BETA.DIST) The cumulative probability function for a beta distribution (only cumulative).

BETAINV (BETA.INV) The inverse of the probability distribution function for a beta distribution.

BIN2DEC The number converted from binary to decimal.

BIN2HEX The number converted from binary to hexadecimal.

BIN2OCT The number converted from binary to octal.

BINOM.DIST The probability of getting a specific number of successes using a binomial distribution.

BINOM.DIST.RANGE The probability of a trial result using a binomial distribution.

BINOM.INV The number of trials needed for a specific amount of success using a binomial distribution.

BINOMDIST (BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution.

BITAND The bitwise AND of two numbers.

BITLSHIFT The number shifted left by a number of bits.

BITOR The bitwise OR of two numbers.

BITRSHIFT The number shifted right by a number of bits.

BITXOR The bitwise Exclusive OR of two numbers.

BYCOL (2021) New. The results from applying a LAMBDA function to each column in an array.

BYROW (2021) New. The results from applying a LAMBDA function to each row in an array.

CALL (Removed in 2003) The specification for a function or command using a registration ID.

CEILING (Compatibility) The number rounded up to the nearest integer or significant figure.

CEILING.MATH The number rounded up to the nearest integer or significant figure (including negative).

CEILING.PRECISE (CEILING.MATH) The number rounded up to the nearest integer or significant figure.

CELL The text string indicating information about a cell.

CHAR The character with the corresponding ANSI/ASCII number.

CHIDIST (CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative).

CHIINV (CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed).

CHISQ.DIST The probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed).

CHISQ.DIST.RT The probability distribution function for a chi-squared distribution (right tailed) (no cumulative).

CHISQ.INV The inverse of the probability distribution function for a chi-squared distribution (left tailed).

CHISQ.INV.RT The inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative).

CHISQ.TEST The probability value from a chi-squared distribution.

CHITEST (CHISQ.TEST) The probability value from a chi-squared distribution.

CHOOSE The value in a row (or column) based on an index number.

CHOOSECOLS (2022) New. The array with just a specific number of columns.

CHOOSEROWS (2022) New. The array with just a specifiic number of rows.

CLEAN The text string with all the non-printable characters removed.

CODE The ANSI/ASCII number for the first character in a text string.

COLUMN The column number of a cell reference.

COLUMNS The number of columns in a cell range or reference.

COMBIN The number of combinations for a given number of items (without repetition).

COMBINA The number of combinations for a given number of items (with repetition).

COMPLEX The complex number given real and imaginary coefficients.

CONCAT (2019) New. The text string that is a concatenation of cell ranges and strings.

CONCATENATE (CONCAT) The text string that is a concatenation of several strings.

CONFIDENCE (CONFIDENCE.NORM) The confidence interval for a population mean.

CONFIDENCE.NORM The confidence interval for a population mean.

CONFIDENCE.T The confidence interval for a population mean using a t distribution.

CONVERT The number in one measurement system converted to another.

CORREL The correlation coefficient between two data sets.

COS The cosine of a number.

COSH The hyperbolic cosine of a number.

COT The cotangent of a number.

COTH The hyperbolic cotangent of a number.

COUNT The number of numerical values.

COUNTA The number of numerical values (including logical values and text).

COUNTBLANK The number of empty cells.

COUNTIF (COUNTIFS) The number of numerical values that satisfies one condition.

COUNTIFS The number of numerical values that satisfies multiple conditions.

COUPDAYBS The number of days between the previous coupon date and the settlement date.

COUPDAYS The number of days between the coupon dates on either side of the settlement date.

COUPDAYSNC The number of days between the settlement date and the next coupon date.

COUPNCD The next coupon date after the settlement date.

COUPNUM The number of coupons between the settlement date and the maturity date.

COUPPCD The previous coupon date before the settlement date.

COVAR (COVARIANCE.P) The covariance based on an entire population.

COVARIANCE.P The covariance based on an entire population.

COVARIANCE.S The covariance based on a sample.

CRITBINOM (BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed).

CSC The cosecant of a number.

CSCH The hyperbolic cosecant of a number.

CUBEKPIMEMBER The name of a key performance indicator.

CUBEMEMBER The member or tuple from a cube.

CUBESET The calculated members returned from a cube.

CUBESETCOUNT The number of items in a set.

CUBEVALUE The aggregated value from a cube.

CUMIPMT The cumulative interest payment on a loan between two dates.

CUMPRINC The cumulative principal paid on a loan between two dates.

DATE The date as a date serial number given a year, month, day.

DATEDIF (Compatibility) The number of days, months or years between two dates.

DATEVALUE The date serial number given a date in text format.

DAVERAGE The arithmetic mean of all the numbers in a column that satisfies multiple conditions.

DAY The day as an integer given a date serial number.

DAYS The number of days between two dates.

DAYS360 The number of days between two dates, based on 30 day months.

DB The depreciation of an asset in a single period (declining balance method).

DBCS (Japanese) The text string converted from single byte to double byte characters.

DCOUNT The number of numerical values in a column that satisfies multiple conditions.

DCOUNTA The number of numerical values in a column that satisfies multiple conditions (including logical values and text).

DDB The depreciation of an asset in a single period (double or triple declining balance method).

DEC2BIN The number converted from decimal to binary.

DEC2HEX The number converted from decimal to hexadecimal.

DEC2OCT The number converted from decimal to octal.

DECIMAL The decimal number of a text representation of a number in a given base.

DEGREES The number of degrees given a number of radians.

DELTA The numerical value indicating if two numbers are equal.

DETECTLANGUAGE (2024) Preview. The language code for the text string provided.

DEVSQ The sum of the squared deviations from the mean.

DGET The single value in a column that satisfies multiple conditions.

DISC The interest rate (or discount rate) for a security held to maturity.

DMAX The largest value in a column that satisfies multiple conditions.

DMIN The smallest value in a column that satisfies multiple conditions.

DOLLAR The text string of a number with the dollar formatting $0,000.00.

DOLLARDE The dollar fraction expressed as a decimal.

DOLLARFR The dollar decimal expressed as a fraction.

DPRODUCT The product of the values in a column that satisfies multiple conditions.

DROP (2022) New. The array without certain rows or columns.

DSTDEV The standard deviation of the values in a column that satisfies multiple conditions based on a sample.

DSTDEVP The standard deviation of the values in a column that satisfies multiple conditions based on an entire population.

DSUM The total of the values in a column that satisfies multiple conditions.

DURATION The annual duration of a security that pays interest periodically.

DVAR The variance of the values in a column that satisfies multiple conditions based on a sample.

DVARP The variance of the values in a column that satisfies multiple conditions based on an entire population.

ECMA.CEILING (Compatibility) The number rounded up to the nearest multiple of significance.

EDATE The date serial number that is a certain number of months before or after a date.

EFFECT The effective interest rate given a nominal interest rate and compounding frequency.

ENCODEURL The url encoded string.

EOMONTH The date serial number of the last day of a month before or after a date.

ERF The value of the error function integrated between two limits.

ERF.PRECISE The value of the error function integrated between 0 and a limit.

ERFC (ERFC.PRECISE) The complementary error function integrated between a limit and infinity.

ERFC.PRECISE The complementary error function integrated between a limit and infinity.

ERROR.TYPE The number corresponding to a particular error value in a cell.

EUROCONVERT (Euro Currency Tools add-in) The number converted to euros.

EVEN The number rounded up to the nearest even integer.

EXACT The value True or False based on whether two strings match exactly.

EXP The exponential number raised to a particular power.

EXPAND (2022) New. The array expanded or padded to specific dimensions.

EXPON.DIST The probability distribution function OR the cumulative probability function for an exponential distribution.

EXPONDIST (EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution.

F.DIST The probability distribution function OR the cumulative probability function for an f distribution (left tailed).

F.DIST.RT The probability distribution function for an f distribution (right tailed) (no cumulative).

F.INV The inverse of the probability distribution function for an f distribution (left tailed).

F.INV.RT The inverse of the probability distribution function for an f distribution (right tailed).

F.TEST The probability value from an f distribution.

FACT The factorial of a positive whole number.

FACTDOUBLE The double factorial of a positive whole number.

FALSE (Compatibility) The logical value False.

FDIST (F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative).

FIELDVALUE (2020) New. The value in a particular field from a linked data type.

FILTER (2021) New. The array after filtering data that satisfies multiple conditions.

FILTERXML The specific data from the xml content by using xpath.

FIND The starting position of a substring within a larger text string (case sensitive).

FINV (F.INV) The inverse of the probability distribution function for an f distribution (left tailed).

FISHER The fisher transformation.

FISHERINV The inverse of the fisher transformation.

FIXED The text string of a number rounded to a fixed number of decimal places.

FLOOR (Compatibility) The number rounded down to the nearest integer or significant figure.

FLOOR.MATH The number rounded down to the nearest integer or significant figure (including negative).

FLOOR.PRECISE (FLOOR.MATH) The number rounded down to the nearest integer or significant figure.

FORECAST (FORECAST.LINEAR) The future y-value along a linear trend using existing values.
FORECAST.ETS The future value based on historical values.

FORECAST.LINEAR The future y-value along a linear trend using existing values.

FORMULATEXT The formula from a particular cell.

FREQUENCY The number of times a particular value occurs.

FTEST (F.TEST) The probability value from an f distribution.

FV The future value of a series of equal cash flows at regular intervals.

FVSCHEDULE The future value of an initial principal after applying compound interest rates.

GAMMA The gamma function value.

GAMMA.DIST The probability distribution function OR the cumulative probability function for a gamma distribution.

GAMMA.INV The inverse of the cumulative probability function for a gamma distribution.

GAMMADIST (GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution.

GAMMAINV (GAMMA.INV) The inverse of the probability distribution for a gamma distribution.

GAMMALN (GAMMALN.PRECISE) The natural logarithm of the gamma function.

GAMMALN.PRECISE The natural logarithm of the gamma function.

GAUSS The 0.5 less than the standard normal cumulative distribution.

GCD The greatest common divisor of two or more numbers.

GEOMEAN The geometric mean of an array of numbers.

GESTEP The value True or False depending if the number is greater than a threshold value.

GETPIVOTDATA The data obtained from a pivot table.

GROUPBY (2023) Preview. The grouping of your data along one axis and aggregates the associated values.

GROWTH The predicted exponential growth using existing data.

HARMEAN The harmonic mean of a data set.

HEX2BIN The number converted from hexadecimal to binary.

HEX2DEC The number converted from hexadecimal to decimal.

HEX2OCT The number converted from hexadecimal to octal.

HLOOKUP (XLOOKUP) The value in the same column after finding a matching value in the first row.

HOUR The hour as an integer given a date serial number.

HSTACK (2022) New. The array after putting multiple arrays next to each other.

HYPERLINK The hyperlink linked to a cell, document or webpage.

HYPGEOM.DIST The probability distribution functon OR the cumulative probability function for a hypergeometric distribution.

HYPGEOMDIST (HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only cumulative).

IF The value based on whether a condition is True or False.

IFERROR The value or something else if it evaluates to an error.

IFNA The value or something else if it evaluates to #N/A.

IFS (2019) New. The value based on multiple True or False conditions.

IMABS The absolute value of a complex number.

IMAGE (2022) New. The image from a web URL.

IMAGINARY The imaginary coefficient of a complex number.

IMARGUMENT The theta argument in radians.

IMCONJUGATE The complex conjugate of a complex number.

IMCOS The cosine of a complex number.

IMCOSH The hyperbolic cosine of a complex number.

IMCOT The cotangent of a complex number.

IMCSC The cosecant of a complex number.

IMCSCH The hyperbolic cosecant of a complex number.

IMDIV The quotient of two complex numbers.

IMEXP The exponential of a complex number.

IMLN The natural logarithm of a complex number.

IMLOG10 The base-10 logarithm of a complex number.

IMLOG2 The base-2 logarithm of a complex number.

IMPOWER The complex number raised to an integer number.

IMPRODUCT The product of two or more complex numbers.

IMREAL The real coefficient of a complex number.

IMSEC The secant of a complex number.

IMSECH The hyperbolic secant of a complex number.

IMSIN The sine of a complex number.

IMSINH The hyperbolic sine of a complex number.

IMSQRT The square root of a complex number.

IMSUB The difference of two complex numbers.

IMSUM The sum of two or more complex numbers.

IMTAN The tangent of a complex number.

INDEX The value from a cell range which is the intersection of a row AND a column.

INDIRECT The value of a given cell reference specified by a text string.

INFO The text string returning useful information about the environment.

INT The number rounded down to the nearest integer.

INTERCEPT The intersection with the y-axis using a linear regression plotted through known values.

INTRATE The interest rate for a security held to maturity.

IPMT The interest amount paid on a given period on a loan with fixed interest.

IRR The interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).

ISBLANK The boolean True or False depending if the value is blank.

ISERR The boolean True or False depending if the value is an error (excluding #N/A).

ISERROR The boolean True or False depending if the value is an error.

ISEVEN The boolean True or False depending if the value is an even number.

ISFORMULA The boolean True or False depending if the cell contains a formula.

ISLOGICAL The boolean True or False depending if the value is True or False.

ISNA The boolean True or False depending if the value is #N/A.

ISNONTEXT The boolean True or False depending if the value is non text.

ISNUMBER The boolean True or False depending if the value is a number.

ISO.CEILING (CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed).

ISODD The boolean True or False depending if the value is an odd number.

ISOMITTED (2021) New. The boolean True or False depending whether the value in a LAMBDA is missing.

ISOWEEKNUM The number of the ISO week of the year for a given date.

ISPMT (Compatibility) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).

ISREF The boolean True or False depending if the value is a cell reference.

ISTEXT The boolean True or False depending if the value is text.

JIS (Japanese) The text string converted from single byte to double byte characters (renamed).

KURT The kurtosis for a list or array of numbers.

LAMBDA (2020) New. The results of a formula added as a named range.

LARGE The kth largest numerical value.

LCM The least common multiple of two or more numbers.

LEFT The first or left most characters in a text string.

LEN The number of characters in a text string.

LET (2021) New. The result of a formula that can use variables.

LINEST The array of values for a straight line that best fits your data.

LN The natural logarithm of a number.

LOG The logarithm of a number to any base.

LOG10 The logarithm of a number to the base 10.

LOGEST The array of values for an exponential curve that best fits your data.

LOGINV (LOGNORM.INV) The inverse of the probability distribution function for a lognormal distribution.

LOGNORM.DIST The probability distribution function OR the cumulative probability function for a lognormal distribution.

LOGNORM.INV The inverse of the probability distribution function for a lognormal distribution.

LOGNORMDIST (LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative).

LOOKUP The value in a row (or column) that matches a value in a column (or row).

LOWER The text string with all the characters converted to lowercase.

MAKEARRAY (2021) New. The array calculated by applying a LAMBDA function.

MAP (2021) New. The array formed by applying a map using a LAMBDA function.

MATCH (XMATCH) The position of a value in a list, table or cell range.

MAX The largest numerical value.

MAXA The largest numerical value (including logical values and text).

MAXIFS (2019) New. The largest numerical value that satisfies multiple conditions.

MDETERM The matrix determinant of an array.

MDURATION The modified duration for a security that pays interest periodically.

MEDIAN The number in the middle of a set of numbers.

MID The characters from the middle of a text string.

MIN The smallest numerical value.

MINA The smallest numerical value (including logical values and text).

MINIFS (2019) New. The smallest numerical value that satisfies multiple conditions.

MINUTE The minute as an integer given a date serial number.

MINVERSE The inverse matrix of an array.

MIRR The interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate).

MMULT The matrix product of two arrays.

MOD The remainder after division.

MODE (MODE.SNGL) The first number that appears the most often in a set.

MODE.MULT The array of all the numbers that appears the most often in a set.

MODE.SNGL The first number that appears the most often in a set.

MONTH The month as an integer given a date serial number.

MROUND The number rounded to the desired multiple.

MULTINOMIAL The number of permutations for a given number of items (with duplicates).

MUNIT The unit matrix or the specified dimension.

N The value converted to a number.

NA The error value #N/A.

NEGBINOM.DIST The probability distribution function OR the cumulative probability function for a negative binomial distribution.

NEGBINOMDIST (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative).

NETWORKDAYS (NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays.

NETWORKDAYS.INTL The total number of working days between two dates excluding weekends and holidays.

NOMINAL The nominal interest rate over a period given an annual interest rate.

NORM.DIST The probability distribution function OR the cumulative probability function for a normal distribution.

NORM.INV The inverse of the probability distribution function for a normal distribution.
NORM.S.DIST The probability distribution function OR the cumulative probability function for a standard normal distribution.

NORM.S.INV The inverse of the probability distribution function for a standard normal distribution.

NORMDIST (NORM.DIST) The probability distribution function OR the cumulative probability function for a normal distribution.

NORMINV (NORM.INV) The inverse of the probability distribution function for a normal distribution.

NORMSDIST (NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative).

NORMSINV (NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution.

NOT The opposite of a True or False value.

NOW The date serial number of the current system date and time.

NPER The number of periods for an investment.

NPV The net present value of a series of unequal cash flows at regular intervals.

NUMBERVALUE The number that a text string represents (current locale).

OCT2BIN The number converted from octal to binary.

OCT2DEC The number converted from octal to decimal.

OCT2HEX The number converted from octal to hexadecimal.

ODD The number rounded up to the nearest odd integer.

ODDFPRICE The price per $100 face value of a security with an odd first period.

ODDFYIELD The yield of a security with an odd first period.

ODDLPRICE The price per $100 face value of a security with an odd last period.

ODDLYIELD The yield of a security with an odd last period.

OFFSET The value in a cell which is an offset from another cell.

OR The boolean True or False depending on multiple conditions.

PDURATION The number of periods required by an investment to reach a specified value.

PEARSON The pearson product moment correlation coefficient.

PERCENTILE (PERCENTILE.INC) The value from a data set that corresponds to a particular percentage (inclusive).

PERCENTILE.EXC The value from a data set that corresponds to a particular percentage (exclusive).

PERCENTILE.INC The value from a data set that corresponds to a particular percentage (inclusive).

PERCENTRANK (PERCENTRANK.INC) The rank of a value as a percentage (inclusive).

PERCENTRANK.EXC The rank of a value as a percentage (exclusive).

PERCENTRANK.INC The rank of a value as a percentage (inclusive).

PERMUT The number of permutations for a subset of objects or events.

PERMUTATIONA The number of permutations for a subset of objects or events (with repetition).

PHI The value of the density function for a standard normal distribution.

PHONETIC The phonetic characters from a text string.

PI The number PI (3.141592).

PIVOTBY (2023) Preview. The grouping of your data along two axis and aggregates the associated values.

PMT The full amount (principal + interest) paid every period on a loan with fixed interest.

POISSON (POISSON.DIST) The probability distribution function OR the cumulative probability function for a poisson distribution.

POISSON.DIST The probability distribution function OR the cumulative probability function for a poisson distribution.

POWER The number raised to a given power.

PPMT The principal amount paid on a given period on a loan with fixed interest.

PRICE The price of a security that pays periodic interest.

PRICEDISC The price of a discounted security (no interest payments).

PRICEMAT The price of a security that pays interest at maturity.

PROB The probability that the values in a data set are greater than a lower limit and less than an upper limit.

PRODUCT The product of all the numerical values.

PROPER The text string with the first letter of every word as a capital letter.
PV The present value of a series of equal cash flows at regular intervals.

PY (2023) New. The value or object after running code in a Python Editor using the Microsoft Cloud runtime.

QUARTILE (QUARTILE.INC) The quartile of a data set (inclusive).

QUARTILE.EXC The quartile of a data set (exclusive).

QUARTILE.INC The quartile of a data set (inclusive).

QUOTIENT The integer portion after division.

RADIANS The number of radians given the number of degrees.

RAND The random number >=0 and <1.

RANDARRAY (2021) New. The array of random numbers between 0 and 1.

RANDBETWEEN The random number between two specified numbers (inclusive).

RANK (RANK.EQ) The rank of a value in descending order (equal ranking).

RANK.AVG The rank of a value in descending order (average ranking).

RANK.EQ The rank of a value in descending order (equal ranking).

RATE The interest rate for a series of equal cash flows at regular intervals.

RECEIVED The amount received at the end when a security is held to maturity.

REDUCE (2021) New. The total value after reducing an array by applying a LAMBDA function.

REGEXEXTRACT (2024) Preview. The characters that match a regular expression.

REGEXREPLACE (2024) Preview. The text string after replacing characters that match a regular expression.

REGEXTEST (2024) Preview. The boolean True or False depending if the regular expression matches any part of a text string.

REGISTER.ID (Removed in 2003) The result after running an Excel 4.0 Macro function.

REPLACE The text string after replacing characters in a specific location.

REPT The text string repeated a number of times.

RIGHT The last or right most characters in a text string.

ROMAN The text string converting a binary number to a roman numeral.

ROUND The number rounded to a specified number of digits.

ROUNDDOWN The number rounded down to a specified number of digits.

ROUNDUP The number rounded up to a specified number of digits.

ROW The row number of a cell reference.

ROWS The number of rows in a cell range or reference.

RRI The equivalent interest rate for the growth of an investment.

RSQ The square of pearson product moment correlation coefficient through data points in known y's and known x's.

RTD The real time data from a program that supports COM.

SCAN (2021) New. The array after applying a LAMBDA function to each value and returns an array.

SEARCH The starting position of a substring within a larger text string (not case sensitive).

SEC The secant of a number.

SECH The hyperbolic secant of a number.

SECOND The number of seconds as an integer given a date serial number.

SEQUENCE (2021) New. The array of sequential numbers.

SERIESSUM The sum of a power series based on a formula.

SHEET The sheet number of the referenced sheet.

SHEETS The number of sheets in a reference.

SIGN The numerical value indicating if a number is positive or negative.

SIN The sine of a number.

SINGLE (2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column.

SINH The hyperbolic sine of a number.

SKEW The number representing the skewness of a distribution based on a sample.

SKEW.P The number representing the skewness of a distribution based on an entire population.

SLN The depreciation of an asset in a single period (straight-line method).

SLOPE The slope of a linear regression line through the given data points.

SMALL The kth smallest numerical value.

SORT (2021) New. The array of data that has been sorted by one column.

SORTBY (2021) New. The array of data that has been sorted based on multiple columns.

SQL.REQUEST (Removed in 2003) The result after connecting to a data source and executes a SQL query.

SQRT The positive square root of a number.

SQRTPI The square root of a number multiplied by PI.

STANDARDIZE The normalized value from a distributed characterised by a mean and a standard deviation.

STDEV (STDEV.S) The standard deviation based on a sample.

STDEV.P The standard deviation based on an entire population.

STDEV.S The standard deviation based on a sample.

STDEVA The standard deviation based on a sample (including logical values and text).

STDEVP (STDEV.P) The standard deviation based on an entire population.

STDEVPA The standard deviation based on an entire population (including logical values and text).

STEYX The standard error of a regression.

STOCKHISTORY (2020) New. The historical data about a financial instrument.

SUBSTITUTE The text string after replacing instances of a substring.

SUBTOTAL (AGGREGATE) The choice of 11 different operations for numerical values (renamed).

SUM The total of the numerical values.

SUMIF (SUMIFS) The total of the numerical values that satisfies one condition.

SUMIFS The total of the numerical values that satisfies multiple conditions.

SUMPRODUCT The sum of the product of one or more arrays of values.

SUMSQ The variation of a data set from its mean.

SUMX2MY2 The sum of the difference of squares of corresponding values in two arrays.

SUMX2PY2 The sum of the sum of squares of corresponding values in two arrays.

SUMXMY2 The sum of squares of differences of corresponding values in two arrays.

SWITCH (2019) New. The value based on a list of exact matches.

SYD The depreciation of an asset in a single period (sum-of-years digits method).

T The text string of the value given.

T.DIST The probability distribution function for a t distribution (left tailed).

T.DIST.2T The probability distribution function for a two tailed distribution (no cumulative).

T.DIST.RT The probability distribution function for a t distribution (right tailed) (no cumulative).

T.INV The inverse of the probability distribution function for a t distribution (left tailed)

T.INV.2T The inverse of the probability distribution function for a two tailed distribution.

T.TEST The probability value from a t distribution.

TAKE (2022) New. The intersection of specific rows and columns in an array.

TAN The tangent of a number.

TANH The hyperbolic tangent of a number.

TBILLEQ The yield (bond-equivalent) for a treasury bill.

TBILLPRICE The price per $100 face value for a treasury bill.

TBILLYIELD The yield for a treasury bill.

TDIST (T.DIST.2T) The percentage points probability for the t distribution.

TEXT The number as a formatted text string.

TEXTAFTER (2022) New. The characters from the end of a text string after a delimiter.
TEXTBEFORE (2022) New. The characters from the start of a text string before a delimiter.

TEXTJOIN (2019) New. The text string that is a concatenation of several strings with a delimiter.

TEXTSPLIT (2022) New. The text string split into multiple columns using delimiters.

TIME The time as a decimal given an hour, minute, second.

TIMEVALUE The time as a decimal given a time in text format.

TINV (T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom.

TOCOL (2022) New. The array transformed into a single column.

TODAY The date serial number representing today's date.

TOROW (2022) New. The array transformed into a single row.

TRANSLATE (2024) Preview. The text string translated into another language.

TRANSPOSE The array with its orientation changed.

TREND The y-values along a linear trend given a set of x-values.

TRIM The text string with all extra spaces removed from the beginning, middle and end.

TRIMMEAN The mean of the interior of a data set.

TRIMRANGE (2024) Preview. The array after excluding all empty rows and/or columns from the outer edges of a range.

TRUE (Compatibility) The logical value True.

TRUNC The number with any decimal places removed.

TTEST (T.TEST) The probability value from a t distribution.

TYPE The number indicating the data type of the value.

UNICHAR The character with the corresponding UNICODE character.

UNICODE The unicode number for the first character in a text string.

UNIQUE (2021) New. The array of unique values in a list, table or cell range.

UPPER The text string with all the characters converted to uppercase.

VALUE (NUMBERVALUE) The number that a text string represents (renamed).

VALUETOTEXT (2021) New. The value converted to text.

VAR (VAR.S) The variance based on a sample.

VAR.P The variance based on an entire population.

VAR.S The variance based on a sample.

VARA The variance based on a sample (including logical values and text).

VARP (VAR.P) The variance based on an entire population.

VARPA The variance based on an entire population (including logical values and text).

VDB The depreciation of an asset in a single period (variable declining balance method).

VLOOKUP (XLOOKUP) The value in the same row after finding a matching value in the first column.

VSTACK (2021) New. The array after putting multiple arrays on top of each other.

WEBSERVICE The results from a webservice.

WEEKDAY The day of the week for a given date.

WEEKNUM The week number in the year for a given date.

WEIBULL (WEIBULL.DIST) The probability distribution function OR the cumulative probability function for a weibull distribution.

WEIBULL.DIST The probability distribution function OR the cumulative probability function for a weibull distribution.

WORKDAY (WORKDAY.INTL) The date serial number that is a given number of working days before or after a date.

WORKDAY.INTL The date serial number that is a given number of working days before or after a date.

WRAPCOLS (2022) New. The array transformed into multiple columns.

WRAPROWS (2022) New. The array transformed into multiple rows.

XIRR The interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate).

XLOOKUP (2021) New. The value in the same row after finding a matching value in any column.

XMATCH (2021) New. The position of a value in a list, table or cell range.
XNPV The net present value of a series of unequal cash flows at irregular intervals.

XOR The boolean True or False depending on multiple conditions.

YEAR The year as an integer given a date serial number.

YEARFRAC The number of years as a decimal between two dates.

YIELD The interest rate (annual) for a series of equal cash flows at regular intervals.

YIELDDISC The interest rate (annual) for a discounted security (no interest payments).

YIELDMAT The interest rate (annual) for a security that pays interest at maturity.

Z.TEST The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values.

ZTEST (Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values.