Complete List

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, table or cell range.
AVERAGEAThe arithmetic mean of the values in a list, table or cell range (including logical values and text).
AVERAGEIF(AVERAGEIFS) The arithmetic mean of the values in a list, table or cell range that satisfies one condition.
AVERAGEIFSThe arithmetic mean of the values in a list, table or cell 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 numerical values in a list, table or cell range.
COUNTAThe number of numerical values in a list, table or cell range (including logical values and text).
COUNTBLANKThe number of empty cells.
COUNTIF(COUNTIFS) The number of numerical values in a list, table or cell range that satisfies one condition.
COUNTIFSThe number of numerical values in a list, table or cell 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 covariance based on an entire population.
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 the values in a column that satisfies multiple conditions based on a sample.
DSTDEVPThe standard deviation of the values in 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 the values in a column that satisfies multiple conditions based on a sample.
DVARPThe 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.
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 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.
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, table or cell range.
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, table or cell range.
MAXAThe largest value in a list, table or cell range (including logical values and text).
MAXIFS(2019) The largest value in a list, table or cell range 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, table or cell range.
MINAThe smallest value in a list, table or cell range (including logical values and text).
MINIFS(2019) The smallest value in a list, table or cell range 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 number of permutations for a given number of items (with duplicates).
MUNIT(2013) The unit matrix or the specified dimension.
NThe value converted to a number.
NAThe error value #N/A.
NEGBINOM.DISTThe 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.INTLThe total number of working days between two dates excluding weekends and holidays.
NOMINALThe nominal interest rate over a period given an annual interest rate.
NORM.DISTThe probability distribution function OR the cumulative probability function for a normal distribution.
NORM.INVThe inverse of the probability distribution function for a normal distribution.
NORM.S.DISTThe probability distribution function OR the cumulative probability function for a standard normal distribution.
NORM.S.INVThe 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.
NOTThe opposite of a True or False value.
NOWThe date serial number of the current system date and time.
NPERThe number of periods for an investment.
NPVThe net present value of a series of unequal cash flows at regular intervals.
NUMBERVALUE(2013) The number that a text string represents (current locale).
OCT2BINThe number converted from octal to binary.
OCT2DECThe number converted from octal to decimal.
OCT2HEXThe number converted from octal to hexadecimal.
ODDThe number rounded up to the nearest odd integer.
ODDFPRICEThe price per $100 face value of a security with an odd first period.
ODDFYIELDThe yield of a security with an odd first period.
ODDLPRICEThe price per $100 face value of a security with an odd last period.
ODDLYIELDThe yield of a security with an odd last period.
OFFSETThe value in a cell which is an offset from another cell.
ORThe logical OR for any number of arguments.
PDURATION(2013) The number of periods required by an investment to reach a specified value.
PEARSONThe pearson product moment correlation coefficient.
PERCENTILE(PERCENTILE.INC) The value from a data set that corresponds to a particular percentage (inclusive).
PERCENTILE.EXCThe value from a data set that corresponds to a particular percentage (exclusive).
PERCENTILE.INCThe 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.EXCThe rank of a value as a percentage (exclusive).
PERCENTRANK.INCThe rank of a value as a percentage (inclusive).
PERMUTThe number of permutations for a subset of objects or events.
PERMUTATIONA(2013) The number of permutations for a subset of objects or events (with repetition).
PHI(2013) The value of the density function for a standard normal distribution.
PHONETICThe phonetic characters from a text string.
PIThe number PI (3.141592).
PIVOTBY(Microsoft 365) The grouping of your data along two axis and aggregates the associated values.
PMTThe 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.DISTThe probability distribution function OR the cumulative probability function for a poisson distribution.
POWERThe number raised to a given power.
PPMTThe principal amount paid on a given period on a loan with fixed interest.
PRICEThe price of a security that pays periodic interest.
PRICEDISCThe price of a discounted security (no interest payments).
PRICEMATThe price of a security that pays interest at maturity.
PROBThe probability that the values in a data set are greater than a lower limit and less than an upper limit.
PRODUCTThe product of all the numbers in a list, table or cell range.
PROPERThe text string with the first letter of every word as a capital letter.
PVThe present value of a series of equal cash flows at regular intervals.
PY(Microsoft 365) 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.EXCThe quartile of a data set (exclusive).
QUARTILE.INCThe quartile of a data set (inclusive).
QUOTIENTThe integer portion after division.
RADIANSThe number of radians given the number of degrees.
RANDThe random number >=0 and <1.
RANDARRAY(2021) The array of random numbers between 0 and 1.
RANDBETWEENThe random number between two specified numbers (inclusive).
RANK(RANK.EQ) The rank of a value in descending order (equal ranking).
RANK.AVGThe rank of a value in descending order (average ranking).
RANK.EQThe rank of a value in descending order (equal ranking).
RATEThe interest rate for a series of equal cash flows at regular intervals.
RECEIVEDThe amount received at the end when a security is held to maturity.
REDUCE(Microsoft 365) The total value after reducing an array by applying a LAMBDA function.
REPLACEThe text string after replacing characters in a specific location.
REPTThe text string repeated a number of times.
RIGHTThe last or right most characters in a text string.
ROMANThe text string converting a binary number to a roman numeral.
ROUNDThe number rounded to a specified number of digits.
ROUNDDOWNThe number rounded down to the nearest integer.
ROUNDUPThe number rounded up to the nearest integer.
ROWThe row number of a cell reference.
ROWSThe number of rows in a cell range or reference.
RRI(2013) The equivalent interest rate for the growth of an investment.
RSQThe square of pearson product moment correlation coefficient through data points in known y's and known x's.
RTDThe real time data from a program that supports COM.
SCAN(Microsoft 365) The array after applying a LAMBDA function to each value and returns an array.
SEARCHThe starting position of a substring within a larger text string.
SEC(2013) The secant of a number.
SECH(2013) The hyperbolic secant of a number.
SECONDThe number of seconds as an integer given a date serial number.
SEQUENCE(2021) The array of sequential numbers.
SERIESSUMThe sum of a power series based on a formula.
SHEET(2013) The sheet number of the referenced sheet.
SHEETS(2013) The number of sheets in a reference.
SIGNThe numerical value indicating if a number is positive or negative.
SINThe 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.
SINHThe hyperbolic sine of a number.
SKEWThe number representing the skewness of a distribution based on a sample.
SKEW.P(2013) The number representing the skewness of a distribution based on an entire population.
SLNThe depreciation of an asset in a single period (straight-line method).
SLOPEThe slope of a linear regression line through the given data points.
SMALLThe kth smallest value in a list, table or cell range.
SORT(2021) The array of data that has been sorted by one column.
SORTBY(2021) The array of data that has been sorted based on multiple columns.
SQRTThe positive square root of a number.
SQRTPIThe square root of a number multiplied by PI.
STANDARDIZEThe normalized value from a distributed characterised by a mean and a standard deviation.
STDEV(STDEV.S) The standard deviation based on a sample.
STDEV.PThe standard deviation based on an entire population.
STDEV.SThe standard deviation based on a sample.
STDEVAThe standard deviation based on a sample (including logical values and text).
STDEVP(STDEV.P) The standard deviation based on an entire population.
STDEVPAThe standard deviation based on an entire population (including logical values and text).
STEYXThe standard error of a regression.
STOCKHISTORY(Microsoft 365) The historical data about a financial instrument.
SUBSTITUTEThe text string after replacing instances of a substring.
SUBTOTAL(AGGREGATE) The subtotal of values in a list, table or cell range (renamed).
SUMThe total of the numerical values in a list, table or cell range.
SUMIF(SUMIFS) The total of the numerical values in a list, table or cell range that satisfies one condition.
SUMIFSThe total of the numerical values in a list, table or cell range that satisfies multiple conditions.
SUMPRODUCTThe sum of the product of one or more arrays of values.
SUMSQThe variation of a data set from its mean.
SUMX2MY2The sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2The sum of the sum of squares of corresponding values in two arrays.
SUMXMY2The sum of squares of differences of corresponding values in two arrays.
SWITCH(2019) The value based on a list of exact matches.
SYDThe depreciation of an asset in a single period (sum-of-years digits method).
TThe text string of the value given.
T.DISTThe probability distribution function for a t distribution (left tailed).
T.DIST.2TThe probability distribution function for a two tailed distribution (no cumulative).
T.DIST.RTThe probability distribution function for a t distribution (right tailed) (no cumulative).
T.INVThe inverse of the probability distribution function for a t distribution (left tailed)
T.INV.2TThe inverse of the probability distribution function for a two tailed distribution.
T.TESTThe probability value from a t distribution.
TAKE(Microsoft 365) The intersection of specific rows and columns in an array.
TANThe tangent of a number.
TANHThe hyperbolic tangent of a number.
TBILLEQThe yield (bond-equivalent) for a treasury bill.
TBILLPRICEThe price per $100 face value for a treasury bill.
TBILLYIELDThe yield for a treasury bill.
TDIST(T.DIST.2T) The percentage points probability for the t distribution.
TEXTThe number as a formatted text string.
TEXTAFTER(Microsoft 365) The characters from the end of a text string after a delimiter.
TEXTBEFORE(Microsoft 365) The characters from the start of a text string before a delimiter.
TEXTJOIN(2019) The text string that is a concatenation of several strings with a delimiter.
TEXTSPLIT(Microsoft 365) The text string split into multiple columns using delimiters.
TIMEThe time as a decimal given an hour, minute, second.
TIMEVALUEThe 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(Microsoft 365) The array transformed into a single column.
TODAYThe date serial number representing today's date.
TOROW(Microsoft 365) The array transformed into a single row.
TRANSPOSEThe array with its orientation changed.
TRENDThe y-values along a linear trend given a set of x-values.
TRIMThe text string with all extra spaces removed from the beginning, middle and end.
TRIMMEANThe mean of the interior of a data set.
TRUEThe logical value True.
TRUNCThe number with any decimal places removed.
TTEST(T.TEST) The probability value from a t distribution.
TYPEThe number indicating the data type of the value.
UNICHAR(2013) The character with the corresponding UNICODE character.
UNICODE(2013) The unicode number for the first character in a text string.
UNIQUE(2021) The array of unique values in a list, table or cell range.
UPPERThe text string with all the characters converted to uppercase.
VALUE(NUMBERVALUE) The number that a text string represents (renamed).
VALUETOTEXT(Microsoft 365) The value converted to text.
VAR(VAR.S) The variance based on a sample.
VAR.PThe variance based on an entire population.
VAR.SThe variance based on a sample.
VARAThe variance based on a sample (including logical values and text).
VARP(VAR.P) The variance based on an entire population.
VARPAThe variance based on an entire population (including logical values and text).
VDBThe depreciation of an asset in a single period (variable declining balance method).
VLOOKUPThe value in the same row after finding a matching value in the first column.
VSTACK(Microsoft 365) The array after putting multiple arrays on top of each other.
WEBSERVICE(2013) The results from a webservice.
WEEKDAYThe day of the week for a given date.
WEEKNUMThe 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.DISTThe 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.INTLThe date serial number that is a given number of working days before or after a date.
WRAPCOLS(Microsoft 365) The array transformed into multiple columns.
WRAPROWS(Microsoft 365) The array transformed into multiple rows.
XIRRThe interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate).
XLOOKUP(2021) The value in the same row after finding a matching value in any column.
XMATCH(2021) The position of a value in a list, table or cell range.
XNPVThe net present value of a series of unequal cash flows at irregular intervals.
XOR(2013) The logical exclusive OR for any number of arguments.
YEARThe year as an integer given a date serial number.
YEARFRACThe number of years as a decimal between two dates.
YIELDThe interest rate (annual) for a series of equal cash flows at regular intervals.
YIELDDISCThe interest rate (annual) for a discounted security (no interest payments).
YIELDMATThe interest rate (annual) for a security that pays interest at maturity.
Z.TESTThe 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.
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, table or cell range.
AVERAGEA
The arithmetic mean of the values in a list, table or cell range (including logical values and text).
AVERAGEIF
(AVERAGEIFS) The arithmetic mean of the values in a list, table or cell range that satisfies one condition.
AVERAGEIFS
The arithmetic mean of the values in a list, table or cell 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 numerical values in a list, table or cell range.
COUNTA
The number of numerical values in a list, table or cell range (including logical values and text).
COUNTBLANK
The number of empty cells.
COUNTIF
(COUNTIFS) The number of numerical values in a list, table or cell range that satisfies one condition.
COUNTIFS
The number of numerical values in a list, table or cell 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 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
(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 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
(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 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.
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, table or cell range.
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, table or cell range.
MAXA
The largest value in a list, table or cell range (including logical values and text).
MAXIFS
(2019) The largest value in a list, table or cell range 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, table or cell range.
MINA
The smallest value in a list, table or cell range (including logical values and text).
MINIFS
(2019) The smallest value in a list, table or cell range 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
(2013) 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
(2013) 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 logical OR for any number of arguments.
PDURATION
(2013) 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
(2013) The number of permutations for a subset of objects or events (with repetition).
PHI
(2013) 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
(Microsoft 365) 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 numbers in a list, table or cell range.
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
(Microsoft 365) 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) 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
(Microsoft 365) The total value after reducing an array by applying a LAMBDA 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 the nearest integer.
ROUNDUP
The number rounded up to the nearest integer.
ROW
The row number of a cell reference.
ROWS
The number of rows in a cell range or reference.
RRI
(2013) 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
(Microsoft 365) 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.
SEC
(2013) The secant of a number.
SECH
(2013) The hyperbolic secant of a number.
SECOND
The number of seconds as an integer given a date serial number.
SEQUENCE
(2021) The array of sequential numbers.
SERIESSUM
The sum of a power series based on a formula.
SHEET
(2013) The sheet number of the referenced sheet.
SHEETS
(2013) 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
(2013) 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 value in a list, table or cell range.
SORT
(2021) The array of data that has been sorted by one column.
SORTBY
(2021) The array of data that has been sorted based on multiple columns.
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
(Microsoft 365) The historical data about a financial instrument.
SUBSTITUTE
The text string after replacing instances of a substring.
SUBTOTAL
(AGGREGATE) The subtotal of values in a list, table or cell range (renamed).
SUM
The total of the numerical values in a list, table or cell range.
SUMIF
(SUMIFS) The total of the numerical values in a list, table or cell range that satisfies one condition.
SUMIFS
The total of the numerical values in a list, table or cell range 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) 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
(Microsoft 365) 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
(Microsoft 365) The characters from the end of a text string after a delimiter.
TEXTBEFORE
(Microsoft 365) The characters from the start of a text string before a delimiter.
TEXTJOIN
(2019) The text string that is a concatenation of several strings with a delimiter.
TEXTSPLIT
(Microsoft 365) 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
(Microsoft 365) The array transformed into a single column.
TODAY
The date serial number representing today's date.
TOROW
(Microsoft 365) The array transformed into a single row.
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.
TRUE
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
(2013) The character with the corresponding UNICODE character.
UNICODE
(2013) The unicode number for the first character in a text string.
UNIQUE
(2021) 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
(Microsoft 365) 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
The value in the same row after finding a matching value in the first column.
VSTACK
(Microsoft 365) The array after putting multiple arrays on top of each other.
WEBSERVICE
(2013) 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
(Microsoft 365) The array transformed into multiple columns.
WRAPROWS
(Microsoft 365) 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) The value in the same row after finding a matching value in any column.
XMATCH
(2021) 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
(2013) The logical exclusive OR for any number of arguments.
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.

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