Alphabetical A - M

ABSThe absolute value or a number without its sign.
ACCRINTThe accrued interest for a security that pays interest periodically.
ACCRINTMThe accrued interest for a security that pays interest at maturity.
ACOSThe arc-cosine of a number.
ACOSHThe hyperbolic arc-cosine of a number.
ACOT(2013) The arc-cotangent of a number.
ACOTH(2013) The hyperbolic arc-cotangent of a number.
ADDRESSThe cell reference given a row and column number.
AGGREGATEThe aggregate of values in a list, table or cell range.
AMORDEGRCThe depreciation of an asset in a single period (straight-line, implicit coefficient).
AMORLINCThe depreciation of an asset in a single period (straight-line).
ANDThe logical AND for any number of arguments.
ARABIC(2013) The number converted from roman to arabic.
AREASThe number of areas in a cell range or reference.
ARRAYTOTEXT(Microsoft 365) The contents of an array or cell ranges converted into text.
ASCThe text string converted from double byte to single byte characters.
ASINThe arc-sine of a number.
ASINHThe hyperbolic arc-sine of a number.
ATANThe arc-tangent of a number.
ATAN2The arc-tangent of the specified x and y co-ordinates.
ATANHThe hyperbolic arc-tangent of a number.
AVEDEVThe average deviation of the numbers in a list, table or cell range.
AVERAGEThe arithmetic mean of the values in a list, range or array.
AVERAGEAThe arithmetic mean of the values in a list, range or array (including logical values and text).
AVERAGEIF(AVERAGEIFS) The arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFSThe arithmetic mean of all the numbers in a range that satisfies multiple conditions.
BAHTTEXTThe number converted to a Thai text string and appends 'Baht'.
BASE(2013) The number converted into a text representation with the given base.
BESSELIThe Bessel function evaluated for purely imaginary arguments.
BESSELJThe modified Bessel function represented by J(x).
BESSELKThe modified Bessel function represented by K(x).
BESSELYThe modified Bessel function represented by Y(x).
BETA.DISTThe probability of getting a specific value between 0 and 1 for different distribution shapes.
BETA.INVThe 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.
BIN2DECThe number converted from binary to decimal.
BIN2HEXThe number converted from binary to hexadecimal.
BIN2OCTThe number converted from binary to octal.
BINOM.DISTThe probability of getting a specific number of successes using a binomial distribution.
BINOM.DIST.RANGE(2013) The probability of a trial result using a binomial distribution.
BINOM.INVThe 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(2013) The bitwise AND of two numbers.
BITLSHIFT(2013) The number shifted left by a number of bits.
BITOR(2013) The bitwise OR of two numbers.
BITRSHIFT(2013) The number shifted right by a number of bits.
BITXOR(2013) The bitwise Exclusive OR of two numbers.
BYCOL(Microsoft 365) The results from applying a LAMBDA function to each column in an array.
BYROW(Microsoft 365) The results from applying a LAMBDA function to each row in an array.
CEILING(CEILING.MATH) The number rounded up to the nearest integer or significant figure.
CEILING.MATH(2013) 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.
CELLThe text string indicating information about a cell.
CHARThe 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.DISTThe probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed).
CHISQ.DIST.RTThe probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHISQ.INVThe inverse of the probability distribution function for a chi-squared distribution (left tailed).
CHISQ.INV.RTThe inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHISQ.TESTThe probability value from a chi-squared distribution.
CHITEST(CHISQ.TEST) The probability value from a chi-squared distribution.
CHOOSEThe value in a row (or column) based on an index number.
CHOOSECOLS(Microsoft 365) The array with just a specific number of columns.
CHOOSEROWS(Microsoft 365) The array with just a specifiic number of rows.
CLEANThe text string with all the non-printable characters removed.
CODEThe ANSI/ASCII number for the first character in a text string.
COLUMNThe column number of a cell reference.
COLUMNSThe number of columns in a cell range or reference.
COMBINThe number of combinations for a given number of items (without repetition).
COMBINA(2013) The number of combinations for a given number of items (with repetition).
COMPLEXThe complex number given real and imaginary coefficients.
CONCAT(2019) 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.NORMThe confidence interval for a population mean.
CONFIDENCE.TThe confidence interval for a population mean using a t distribution.
CONVERTThe number in one measurement system converted to another.
CORRELThe correlation coefficient between two data sets.
COSThe cosine of a number.
COSHThe hyperbolic cosine of a number.
COT(2013) The cotangent of a number.
COTH(2013) The hyperbolic cotangent of a number.
COUNTThe number of values in a list, range or array.
COUNTAThe number of values that are not empty cells.
COUNTBLANKThe number of blank cells in a list, table or range.
COUNTIF(COUNTIFS) The number of numerical values in a range that satisfies one condition.
COUNTIFSThe number of numerical values in a range that satisfies multiple conditions.
COUPDAYBSThe number of days between the previous coupon date and the settlement date.
COUPDAYSThe number of days between the coupon dates on either side of the settlement date.
COUPDAYSNCThe number of days between the settlement date and the next coupon date.
COUPNCDThe next coupon date after the settlement date.
COUPNUMThe number of coupons between the settlement date and the maturity date.
COUPPCDThe previous coupon date before the settlement date.
COVAR(COVARIANCE.P) The average of the products of deviations for each data point pair.
COVARIANCE.PThe covariance based on an entire population.
COVARIANCE.SThe covariance based on a sample.
CRITBINOM(BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed).
CSC(2013) The cosecant of a number.
CSCH(2013) The hyperbolic cosecant of a number.
CUBEKPIMEMBERThe name of a key performance indicator.
CUBEMEMBERThe member or tuple from a cube.
CUBESETThe calculated members returned from a cube.
CUBESETCOUNTThe number of items in a set.
CUBEVALUEThe aggregated value from a cube.
CUMIPMTThe cumulative interest payment on a loan between two dates.
CUMPRINCThe cumulative principal paid on a loan between two dates.
DATEThe date as a date serial number given a year, month, day.
DATEDIF(Compatibility) The number of days, months or years between two dates.
DATEVALUEThe date serial number given a date in text format.
DAVERAGEThe arithmetic mean of all the numbers in a column that satisfies multiple conditions.
DAYThe day as an integer given a date serial number.
DAYS(2013) The number of days between two dates.
DAYS360The number of days between two dates, based on 30 day months.
DBThe depreciation of an asset in a single period (declining balance method).
DBCS(2013) The text string converted from single byte to double byte characters.
DCOUNTThe number of numerical values in a column that satisfies multiple conditions.
DCOUNTAThe number of numerical values in a column that satisfies multiple conditions (including logical values and text).
DDBThe depreciation of an asset in a single period (double or triple declining balance method).
DEC2BINThe number converted from decimal to binary.
DEC2HEXThe number converted from decimal to hexadecimal.
DEC2OCTThe number converted from decimal to octal.
DECIMAL(2013) The decimal number of a text representation of a number in a given base.
DEGREESThe number of degrees given a number of radians.
DELTAThe numerical value indicating if two numbers are equal.
DEVSQThe sum of the squared deviations from the mean.
DGETThe single value in a column that satisfies multiple conditions.
DISCThe interest rate (or discount rate) for a security held to maturity.
DMAXThe largest value in a column that satisfies multiple conditions.
DMINThe smallest value in a column that satisfies multiple conditions.
DOLLARThe text string of a number with the dollar formatting $0,000.00.
DOLLARDEThe dollar fraction expressed as a decimal.
DOLLARFRThe dollar decimal expressed as a fraction.
DPRODUCTThe product of the values in a column that satisfies multiple conditions.
DROP(Microsoft 365) The array without certain rows or columns.
DSTDEVThe standard deviation of a column that satisfies multiple conditions based on a sample.
DSTDEVPThe standard deviation of a column that satisfies multiple conditions based on an entire population.
DSUMThe total of the values in a column that satisfies multiple conditions.
DURATIONThe annual duration of a security that pays interest periodically.
DVARThe variance of a column that satisfies multiple conditions based on a sample.
DVARPThe variance of a column that satisfies multiple conditions based on an entire population.
ECMA.CEILING(Compatibility) The number rounded up to the nearest multiple of significance.
EDATEThe date serial number that is a certain number of months before or after a date.
EFFECTThe effective interest rate given a nominal interest rate and compounding frequency.
ENCODEURL(2013) The url encoded string.
EOMONTHThe date serial number of the last day of a month before or after a date.
ERFThe value of the error function integrated between two limits.
ERF.PRECISEThe 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.PRECISEThe complementary error function integrated between a limit and infinity.
ERROR.TYPEThe number corresponding to a particular error value in a cell.
EUROCONVERTThe number converted to euros.
EVENThe number rounded up to the nearest even integer.
EXACTThe value True or False based on whether two strings match exactly.
EXPThe exponential number raised to a particular power.
EXPAND(Microsoft 365) The array expanded or padded to specific dimensions.
EXPON.DISTThe 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.DISTThe probability distribution function OR the cumulative probability function for an f distribution (left tailed).
F.DIST.RTThe probability distribution function for an f distribution (right tailed) (no cumulative).
F.INVThe inverse of the probability distribution function for an f distribution (left tailed).
F.INV.RTThe inverse of the probability distribution function for an f distribution (right tailed).
F.TESTThe probability value from an f distribution.
FACTThe factorial of a positive whole number.
FACTDOUBLEThe double factorial of a positive whole number.
FALSEThe logical value False.
FDIST(F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative).
FIELDVALUE(Microsoft 365) The value in a particular field from a linked data type.
FILTER(2021) The array after filtering data in a range that satisfies multiple conditions.
FILTERXML(2013) The specific data from the xml content by using xpath.
FINDThe starting position of a substring within a larger text string.
FINV(F.INV) The inverse of the probability distribution function for an f distribution (left tailed).
FISHERThe fisher transformation.
FISHERINVThe inverse of the fisher transformation.
FIXEDThe text string of a number rounded to a fixed number of decimal places.
FLOOR(FLOOR.MATH) The number rounded down to the nearest integer or significant figure.
FLOOR.MATH(2013) 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(2016) The future value based on historical values.
FORECAST.LINEAR(2016) The future y-value along a linear trend using existing values.
FORMULATEXT(2013) The formula from a particular cell.
FREQUENCYThe number of times a particular value occurs in a list, table or cell range.
FTEST(F.TEST) The probability value from an f distribution.
FVThe future value of a series of equal cash flows at regular intervals.
FVSCHEDULEThe future value of an initial principal after applying compound interest rates.
GAMMA(2013) The gamma function value.
GAMMA.DISTThe probability distribution function OR the cumulative probability function for a gamma distribution.
GAMMA.INVThe 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.PRECISEThe natural logarithm of the gamma function.
GAUSS(2013) The 0.5 less than the standard normal cumulative distribution.
GCDThe greatest common divisor of two or more numbers.
GEOMEANThe geometric mean of an array of numbers.
GESTEPThe value True or False depending if the number is greater than a threshold value.
GETPIVOTDATAThe data obtained from a pivot table.
GROUPBY(Microsoft 365) The grouping of your data along one axis and aggregates the associated values.
GROWTHThe predicted exponential growth using existing data.
HARMEANThe harmonic mean of a data set.
HEX2BINThe number converted from hexadecimal to binary.
HEX2DECThe number converted from hexadecimal to decimal.
HEX2OCTThe number converted from hexadecimal to octal.
HLOOKUPThe value in the same column after finding a matching value in the first row.
HOURThe hour as an integer given a date serial number.
HSTACK(Microsoft 365) The array after putting multiple arrays next to each other.
HYPERLINKThe hyperlink linked to a cell, document or webpage.
HYPGEOM.DISTThe 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).
IFThe value based on whether a condition is True or False.
IFERRORThe value or something else if it evaluates to an error.
IFNA(2013) The value or something else if it evaluates to #N/A.
IFS(2019) The value based on multiple True or False conditions.
IMABSThe absolute value of a complex number.
IMAGE(Microsoft 365) The image from a web URL.
IMAGINARYThe imaginary coefficient of a complex number.
IMARGUMENTThe theta argument in radians.
IMCONJUGATEThe complex conjugate of a complex number.
IMCOSThe cosine of a complex number.
IMCOSH(2013) The hyperbolic cosine of a complex number.
IMCOT(2013) The cotangent of a complex number.
IMCSC(2013) The cosecant of a complex number.
IMCSCH(2013) The hyperbolic cosecant of a complex number.
IMDIVThe quotient of two complex numbers.
IMEXPThe exponential of a complex number.
IMLNThe natural logarithm of a complex number.
IMLOG10The base-10 logarithm of a complex number.
IMLOG2The base-2 logarithm of a complex number.
IMPOWERThe complex number raised to an integer number.
IMPRODUCTThe product of two or more complex numbers.
IMREALThe real coefficient of a complex number.
IMSEC(2013) The secant of a complex number.
IMSECH(2013) The hyperbolic secant of a complex number.
IMSINThe sine of a complex number.
IMSINH(2013) The hyperbolic sine of a complex number.
IMSQRTThe square root of a complex number.
IMSUBThe difference of two complex numbers.
IMSUMThe sum of two or more complex numbers.
IMTAN(2013) The tangent of a complex number.
INDEXThe value from a cell range which is the intersection of a row AND a column.
INDIRECTThe value of a given cell reference specified by a text string.
INFOThe text string returning useful information about the environment.
INTThe number rounded down to the nearest integer.
INTERCEPTThe intersection with the y-axis using a linear regression plotted through known values.
INTRATEThe interest rate for a security held to maturity.
IPMTThe interest amount paid on a given period on a loan with fixed interest.
IRRThe interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
ISBLANKThe boolean True or False depending if the value is blank.
ISERRThe boolean True or False depending if the value is an error (not #N/A).
ISERRORThe boolean True or False depending if the value is an error.
ISEVENThe boolean True or False depending if the value is an even number.
ISFORMULA(2013) The boolean True or False depending if the cell contains a formula.
ISLOGICALThe boolean True or False depending if the value is True or False.
ISNAThe boolean True or False depending if the value is #N/A.
ISNONTEXTThe boolean True or False depending if the value is non text.
ISNUMBERThe 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).
ISODDThe boolean True or False depending if the value is an odd number.
ISOMITTED(Microsoft 365) The boolean True or False depending whether the value in a LAMBDA is missing.
ISOWEEKNUM(2013) The number of the ISO week of the year for a given date.
ISPMT(IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).
ISREFThe boolean True or False depending if the value is a cell reference.
ISTEXTThe boolean True or False depending if the value is text.
JIS(DBCS) The text string converted from single byte to double byte characters (renamed).
KURTThe kurtosis for a list or array of numbers.
LAMBDA(Microsoft 365) The results of a formula added as a named range.
LARGEThe kth largest value in a list or array of numbers.
LCMThe least common multiple of two or more numbers.
LEFTThe first or left most characters in a text string.
LENThe number of characters in a text string.
LET(2021) The result of a formula that can use variables.
LINESTThe array of values for a straight line that best fits your data.
LNThe natural logarithm of a number.
LOGThe logarithm of a number to any base.
LOG10The logarithm of a number to the base 10.
LOGESTThe 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.DISTThe probability distribution function OR the cumulative probability function for a lognormal distribution.
LOGNORM.INVThe inverse of the probability distribution function for a lognormal distribution.
LOGNORMDIST(LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative).
LOOKUPThe value in a row (or column) that matches a value in a column (or row).
LOWERThe text string with all the characters converted to lowercase.
MAKEARRAY(Microsoft 365) The array calculated by applying a LAMBDA function.
MAP(Microsoft 365) The array formed by applying a map using a LAMBDA function.
MATCHThe position of a value in a list, table or cell range.
MAXThe largest value in a list, range or array.
MAXAThe largest value in a list, range or array (including logical values and text).
MAXIFS(2019) The largest value in a list, range or array that satisfies multiple conditions.
MDETERMThe matrix determinant of an array.
MDURATIONThe modified duration for a security that pays interest periodically.
MEDIANThe number in the middle of a set of numbers.
MIDThe characters from the middle of a text string.
MINThe smallest value in a list, range or array.
MINAThe smallest value in a list, range or array (including logical values and text).
MINIFS(2019) The smallest value in a list, range or array that satisfies multiple conditions.
MINUTEThe minute as an integer given a date serial number.
MINVERSEThe inverse matrix of an array.
MIRRThe interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
MMULTThe matrix product of two arrays.
MODThe remainder after division.
MODE(MODE.SNGL) The first number that appears the most often in a set.
MODE.MULTThe array of all the numbers that appears the most often in a set.
MODE.SNGLThe first number that appears the most often in a set.
MONTHThe month as an integer given a date serial number.
MROUNDThe number rounded to the desired multiple.
MULTINOMIALThe multinomial of a set of numbers in a list or cell range.
MUNIT(2013) The unit matrix or the specified dimension.
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
(2013) The arc-cotangent of a number.
ACOTH
(2013) The hyperbolic arc-cotangent of a number.
ADDRESS
The cell reference given a row and column number.
AGGREGATE
The aggregate of values in a list, table or cell range.
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 logical AND for any number of arguments.
ARABIC
(2013) The number converted from roman to arabic.
AREAS
The number of areas in a cell range or reference.
ARRAYTOTEXT
(Microsoft 365) The contents of an array or cell ranges converted into text.
ASC
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 numbers in a list, table or cell range.
AVERAGE
The arithmetic mean of the values in a list, range or array.
AVERAGEA
The arithmetic mean of the values in a list, range or array (including logical values and text).
AVERAGEIF
(AVERAGEIFS) The arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFS
The arithmetic mean of all the numbers in a range that satisfies multiple conditions.
BAHTTEXT
The number converted to a Thai text string and appends 'Baht'.
BASE
(2013) 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 of getting a specific value between 0 and 1 for different distribution shapes.
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
(2013) 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
(2013) The bitwise AND of two numbers.
BITLSHIFT
(2013) The number shifted left by a number of bits.
BITOR
(2013) The bitwise OR of two numbers.
BITRSHIFT
(2013) The number shifted right by a number of bits.
BITXOR
(2013) The bitwise Exclusive OR of two numbers.
BYCOL
(Microsoft 365) The results from applying a LAMBDA function to each column in an array.
BYROW
(Microsoft 365) The results from applying a LAMBDA function to each row in an array.
CEILING
(CEILING.MATH) The number rounded up to the nearest integer or significant figure.
CEILING.MATH
(2013) 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
(Microsoft 365) The array with just a specific number of columns.
CHOOSEROWS
(Microsoft 365) 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
(2013) The number of combinations for a given number of items (with repetition).
COMPLEX
The complex number given real and imaginary coefficients.
CONCAT
(2019) 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
(2013) The cotangent of a number.
COTH
(2013) The hyperbolic cotangent of a number.
COUNT
The number of values in a list, range or array.
COUNTA
The number of values that are not empty cells.
COUNTBLANK
The number of blank cells in a list, table or range.
COUNTIF
(COUNTIFS) The number of numerical values in a range that satisfies one condition.
COUNTIFS
The number of numerical values in a range 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 average of the products of deviations for each data point pair.
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
(2013) The cosecant of a number.
CSCH
(2013) 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
(2013) 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
(2013) 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
(2013) 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.
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
(Microsoft 365) The array without certain rows or columns.
DSTDEV
The standard deviation of a column that satisfies multiple conditions based on a sample.
DSTDEVP
The standard deviation of 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 a column that satisfies multiple conditions based on a sample.
DVARP
The variance of 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
(2013) 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
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
(Microsoft 365) 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
The logical value False.
FDIST
(F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative).
FIELDVALUE
(Microsoft 365) The value in a particular field from a linked data type.
FILTER
(2021) The array after filtering data in a range that satisfies multiple conditions.
FILTERXML
(2013) The specific data from the xml content by using xpath.
FIND
The starting position of a substring within a larger text string.
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
(FLOOR.MATH) The number rounded down to the nearest integer or significant figure.
FLOOR.MATH
(2013) 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
(2016) The future value based on historical values.
FORECAST.LINEAR
(2016) The future y-value along a linear trend using existing values.
FORMULATEXT
(2013) The formula from a particular cell.
FREQUENCY
The number of times a particular value occurs in a list, table or cell range.
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
(2013) 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
(2013) 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
(Microsoft 365) 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
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
(Microsoft 365) 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
(2013) The value or something else if it evaluates to #N/A.
IFS
(2019) The value based on multiple True or False conditions.
IMABS
The absolute value of a complex number.
IMAGE
(Microsoft 365) 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
(2013) The hyperbolic cosine of a complex number.
IMCOT
(2013) The cotangent of a complex number.
IMCSC
(2013) The cosecant of a complex number.
IMCSCH
(2013) 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
(2013) The secant of a complex number.
IMSECH
(2013) The hyperbolic secant of a complex number.
IMSIN
The sine of a complex number.
IMSINH
(2013) 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
(2013) 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 (not #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
(2013) 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
(Microsoft 365) The boolean True or False depending whether the value in a LAMBDA is missing.
ISOWEEKNUM
(2013) The number of the ISO week of the year for a given date.
ISPMT
(IPMT) 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
(DBCS) The text string converted from single byte to double byte characters (renamed).
KURT
The kurtosis for a list or array of numbers.
LAMBDA
(Microsoft 365) The results of a formula added as a named range.
LARGE
The kth largest value in a list or array of numbers.
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) 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
(Microsoft 365) The array calculated by applying a LAMBDA function.
MAP
(Microsoft 365) The array formed by applying a map using a LAMBDA function.
MATCH
The position of a value in a list, table or cell range.
MAX
The largest value in a list, range or array.
MAXA
The largest value in a list, range or array (including logical values and text).
MAXIFS
(2019) The largest value in a list, range or array 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 value in a list, range or array.
MINA
The smallest value in a list, range or array (including logical values and text).
MINIFS
(2019) The smallest value in a list, range or array 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 multinomial of a set of numbers in a list or cell range.
MUNIT
(2013) The unit matrix or the specified dimension.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top