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.
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 non blank cells in a list, table or cell range.
AVERAGEAThe arithmetic mean of non blank cells in a list, table or cell range (including logical values and text).
AVERAGEIFThe 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 less than or equal to a particular value in a beta distribution.
BETA.INVThe probability of getting greater than a particular value in a beta distribution.
BETADIST(BETA.DIST) The probability of getting less than or equal to a particular value in a beta distribution.
BETAINV(BETA.INV) The probability of getting greater than a particular value in 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 less than or equal to a particular value in a binomial distribution.
BINOM.DIST.RANGE(2013) The probability of a trial result using a binomial distribution.
BINOM.INVThe probability of getting greater than a particular value in a binomial distribution.
BINOMDIST(BINOM.DIST) The probability of getting less than or equal to a particular value in 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.
CALLThe results from a procedure in a DLL or code resource.
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 of getting less than or equal to a particular value in a chi-squared distribution (right tailed).
CHIINV(CHISQ.INV.RT) The probability of getting greater than a particular value in a chi-squared distribution (right tailed).
CHISQ.DISTThe probability of getting less than or equal to a particular value in a chi-squared distribution (left tailed).
CHISQ.DIST.RTThe probability of getting more than a particular value in a chi-squared distribution (right tailed).
CHISQ.INVThe probability of getting greater than a particular value in a chi-squared distribution (left tailed).
CHISQ.INV.RTThe probability of getting more than a particular value in a chi-squared distribution (right tailed).
CHISQ.TESTThe value from the chi-squared distribution.
CHITEST(CHISQ.TEST) The value from the chi-squared distribution.
CHOOSEThe value in a row (or column) based on an index number.
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.
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 several 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 non blank cells in a list, table or cell range.
COUNTAThe number of non blank cells in a list, table or cell range (including logical values and text).
COUNTBLANKThe number of blank cells in a list, table or cell range.
COUNTIFThe number of non blank cells that satisfies one condition.
COUNTIFSThe number of non blank cells 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 probability of getting greater than a particular value in a binomial distribution.
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 returns from a cube.
CUBESETCOUNTThe number of items in a set.
CUBEVALUEThe aggregated value from a cube.
CUMIPMTThe cumulative interest paid 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 units between two dates.
DATEVALUEThe date serial number given a date in text format.
DAVERAGEThe arithmetic mean of non blank cells in a database column satisfying certain 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 total number of non blank cells in a database column satisfying certain conditions.
DCOUNTAThe total number of non blank cells in a database column satisfying certain 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 database column satisfying certain conditions.
DISCThe interest rate (or discount rate) for a security held to maturity.
DMAXThe maximum value in a database column satisfying certain conditions.
DMINThe minimum value in a database column satisfying certain 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 values in a database column satisfying certain conditions.
DSTDEVThe standard deviation of a database column satisfying certain conditions based on a sample.
DSTDEVPThe standard deviation of a database column satisfying certain conditions based on an entire population.
DSUMThe sum of values in a database column satisfying certain conditions.
DURATIONThe annual duration of a security that pays interest periodically.
DVARThe variance of a database column satisfying certain conditions based on a sample.
DVARPThe variance of a database column satisfying certain conditions based on an entire population.
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 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.
EXPON.DISTThe exponential distribution.
EXPONDIST(EXPON.DIST) The exponential distribution.
F.DISTThe probability of getting less than or equal to a particular value in an f distribution (left tailed).
F.DIST.RTThe probability of getting less than or equal to a particular value in an f distribution (right tailed).
F.INVThe probability of getting greater than a particular value in an f distribution (left tailed).
F.INV.RTThe probability of getting greater than a particular value in an f distribution (right tailed).
F.TESTThe value from the f test.
FACTThe factorial of a number.
FACTDOUBLEThe double factorial of a number.
FALSEThe logical value False.
FDIST(F.DIST) The probability of getting less than or equal to a particular value in an f distribution (no cumulative) (left tailed).
FIELDVALUE(Office 365) The field data from a Stocks or Geography linked data type.
FILTER(Office 365) The array of data in a range that satisfies multiple conditions.
FILTERXML(2013) The specific data from the xml content by using xpath.
FINDThe position of a substring within a larger text string.
FINV(F.INV) The probability of getting greater than a particular value in 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 (inc. 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 value from the f test.
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 of getting less than or equal to a particular value in a gamma distribution.
GAMMA.INVThe probability of getting greater than a particular value in a gamma distribution.
GAMMADIST(GAMMA.DIST) The probability of getting less than or equal to a particular value in a gamma distribution.
GAMMAINV(GAMMA.INV) The probability of getting greater than a particular value in 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.
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.
HYPERLINKThe hyperlink linked to a cell, document or webpage.
HYPGEOM.DISTThe probability of getting less than or equal to a particular value in a hyper geometric distribution (finite population).
HYPGEOMDIST(HYPGEOM.DIST) The probability of getting less than or equal to a particular value in a hyper geometric distribution (finite population) (no cumulative).
IFThe value based on a condition you specify.
IFERRORThe value based on an error condition you specify.
IFNA(2013) The value True or False depending if the value is #N/A.
IFS(2019) The value based on multiple conditions you specify.
IMABSThe absolute value of a complex number.
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 text string of the contents of a given cell reference.
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 paid for a given period in a series of equal cash flows at regular intervals.
IRRThe interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
ISBLANKThe value True or False depending if the value is blank.
ISERRThe value True or False depending if the value is an error (not #N/A).
ISERRORThe value True or False depending if the value is an error.
ISEVENThe value True or False depending if the value is an even number.
ISFORMULA(2013) The value True or False depending if the cell contains a formula.
ISLOGICALThe value True or False depending if the value is True or False.
ISNAThe value True or False depending if the value is #N/A.
ISNONTEXTThe value True or False depending if the value is non text.
ISNUMBERThe value 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 value True or False depending if the value is an odd number.
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 value True or False depending if the value is a cell reference.
ISTEXTThe value 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.
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.
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 probability of getting greater than a particular value in a lognormal distribution.
LOGNORM.DISTThe probability of getting less than or equal to a particular value in a lognormal distribution.
LOGNORM.INVThe probability of getting greater than a particular value in a lognormal distribution.
LOGNORMDIST(LOGNORM.DIST) The probability of getting less than or equal to a particular value in a lognormal distribution (no 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.
MATCHThe position of a value in a list, table or cell range.
MAXThe largest value in a list or array of numbers.
MAXAThe largest value in a list or array of numbers (including logical values and text).
MAXIFS(2019) The largest value in a list or array of numbers that satisfies multiple conditions.
MDETERMThe matrix determinant of an array.
MDURATIONThe modified duration for a security that pays interest periodically.
MEDIANThe median value in a list or array of numbers.
MIDThe text string which is a substring of a given string.
MINThe smallest value in a list or array of numbers.
MINAThe smallest value in a list or array of numbers (including logical values and text).
MINIFS(2019) The smallest value in a list or array of numbers that satisfies multiple conditions.
MINUTEThe minute as an integer given a date serial number.
MINVERSEThe inverse matrix of an array.
MIRRThe internal rate of return 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 value that occurs most frequently in a list or array of numbers.
MODE.MULTThe array of most frequent or repetitive values.
MODE.SNGLThe value that occurs most frequently in a list or array of numbers.
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.
NThe value converted to a number.
NAThe error value #N/A.
NEGBINOM.DISTThe probability of getting less than or equal to a particular value in a negative binomial distribution.
NEGBINOMDIST(NEGBINOM.DIST) The probability of getting less than or equal to a particular value in 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 of getting less than or equal to a particular value in a normal distribution.
NORM.INVThe x variable corresponding to less than a particular probability.
NORM.S.DISTThe probability of getting less than or equal to a particular value in a standard normal distribution.
NORM.S.INVThe x variable corresponding to less than a particular probability.
NORMDIST(NORM.DIST) The probability of getting less than or equal to a particular value in a normal distribution.
NORMINV(NORM.INV) The x variable corresponding to less than a particular probability.
NORMSDIST(NORM.S.DIST) The probability of getting less than or equal to a particular value in a normal distribution (no cumulative).
NORMSINV(NORM.S.INV) The x variable corresponding to less than a particular probability.
NOTThe opposite of a True or False value.
NOWThe serial number of the current system date and time.
NPERThe number of periods for an investment.
NPVThe 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 number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTILE.EXCThe number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INCThe number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTRANK(PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive).
PERCENTRANK.EXCThe percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INCThe percentage rank of a value in an array of numbers (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).
PMTThe payment for a loan with constant payments and fixed interest.
POISSON(POISSON.DIST) The probability of getting less than or equal to a particular value in a poisson distribution.
POISSON.DISTThe probability of getting less than or equal to a particular value in a poisson distribution.
POWERThe number raised to a given power.
PPMTThe fixed payment made in each period of a series of equal cash flows at regular intervals.
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 values in a range are between two limits.
PRODUCTThe product of all the numbers in a list 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.
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(365 Insiders) 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 a list, table or cell range (in descending order) (equal ranking).
RANK.AVGThe rank of a value in a list, table or cell range (in descending order) (average ranking).
RANK.EQThe rank of a value in a list, table or cell range (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.
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.
SEARCHThe 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(365 Insiders) 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(365 Insiders) 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 or array of numbers.
SORT(365 Insiders) The array of data in a range that has been sorted.
SORTBY(365 Insiders) The array of data in a range that has been sorted and satisfies multiple conditions.
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.
SUBSTITUTEThe text string after replacing instances of a substring.
SUBTOTAL(AGGREGATE) The subtotal of values in a list, table or cell range.
SUMThe total value of the numbers in a list, table or cell range.
SUMIFThe total value of the numbers that satisfies one condition.
SUMIFSThe total value of the numbers that satisfies multiple conditions.
SUMPRODUCTThe sum of the product of one or more arrays of values.
SUMSQThe sum of the squares of all the values in a list, table or cell range.
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 the first matching item.
SYDThe depreciation of an asset in a single period (sum-of-years digits method).
TThe text string of the value given.
T.DISTThe probability of getting less than or equal to a particular value in a t distribution (left tailed).
T.DIST.2TThe percentage points probability for the t distribution.
T.DIST.RTThe probability of getting greater than a particular value in a t distribution (right tailed).
T.INVThe probability of getting greater than a particular value in a t distribution (left tailed)
T.INV.2TThe t value of the t distribution as a function of the probability and the degrees of freedom.
T.TESTThe probability associated with a t test.
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.
TEXTJOIN(2019) The text string that is a concatenation of several strings (with delimiter).
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.
TODAYThe serial number representing today's date.
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 associated with a t test.
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(365 Insiders) 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).
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.
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 of getting less than or equal to a particular value in a weibull distribution.
WEIBULL.DISTThe probability of getting less than or equal to a particular value in a weibull distribution.
WORKDAY(WORKDAY.INTL) The serial number that is a given number of working days before or after a date.
WORKDAY.INTLThe serial number that is a given number of working days before or after a date.
XIRRThe interest rate for a series of unequal cash flows at irregular intervals.
XLOOKUP(365 Insiders) The value in the same row after finding a matching value in any column.
XMATCH(365 Insiders) The position of a value in a list, table or cell range.
XNPVThe present value for 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 two-tailed p-value of a z-test.
ZTEST(Z.TEST) The two-tailed p-value of a z-test.
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.
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 non blank cells in a list, table or cell range.
AVERAGEA
The arithmetic mean of non blank cells in a list, table or cell range (including logical values and text).
AVERAGEIF
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 less than or equal to a particular value in a beta distribution.
BETA.INV
The probability of getting greater than a particular value in a beta distribution.
BETADIST
(BETA.DIST) The probability of getting less than or equal to a particular value in a beta distribution.
BETAINV
(BETA.INV) The probability of getting greater than a particular value in 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 less than or equal to a particular value in a binomial distribution.
BINOM.DIST.RANGE
(2013) The probability of a trial result using a binomial distribution.
BINOM.INV
The probability of getting greater than a particular value in a binomial distribution.
BINOMDIST
(BINOM.DIST) The probability of getting less than or equal to a particular value in 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.
CALL
The results from a procedure in a DLL or code resource.
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 of getting less than or equal to a particular value in a chi-squared distribution (right tailed).
CHIINV
(CHISQ.INV.RT) The probability of getting greater than a particular value in a chi-squared distribution (right tailed).
CHISQ.DIST
The probability of getting less than or equal to a particular value in a chi-squared distribution (left tailed).
CHISQ.DIST.RT
The probability of getting more than a particular value in a chi-squared distribution (right tailed).
CHISQ.INV
The probability of getting greater than a particular value in a chi-squared distribution (left tailed).
CHISQ.INV.RT
The probability of getting more than a particular value in a chi-squared distribution (right tailed).
CHISQ.TEST
The value from the chi-squared distribution.
CHITEST
(CHISQ.TEST) The value from the chi-squared distribution.
CHOOSE
The value in a row (or column) based on an index number.
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.
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 several 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 non blank cells in a list, table or cell range.
COUNTA
The number of non blank cells in a list, table or cell range (including logical values and text).
COUNTBLANK
The number of blank cells in a list, table or cell range.
COUNTIF
The number of non blank cells that satisfies one condition.
COUNTIFS
The number of non blank cells 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 probability of getting greater than a particular value in a binomial distribution.
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 returns from a cube.
CUBESETCOUNT
The number of items in a set.
CUBEVALUE
The aggregated value from a cube.
CUMIPMT
The cumulative interest paid 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 units between two dates.
DATEVALUE
The date serial number given a date in text format.
DAVERAGE
The arithmetic mean of non blank cells in a database column satisfying certain 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 total number of non blank cells in a database column satisfying certain conditions.
DCOUNTA
The total number of non blank cells in a database column satisfying certain 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 database column satisfying certain conditions.
DISC
The interest rate (or discount rate) for a security held to maturity.
DMAX
The maximum value in a database column satisfying certain conditions.
DMIN
The minimum value in a database column satisfying certain 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 values in a database column satisfying certain conditions.
DSTDEV
The standard deviation of a database column satisfying certain conditions based on a sample.
DSTDEVP
The standard deviation of a database column satisfying certain conditions based on an entire population.
DSUM
The sum of values in a database column satisfying certain conditions.
DURATION
The annual duration of a security that pays interest periodically.
DVAR
The variance of a database column satisfying certain conditions based on a sample.
DVARP
The variance of a database column satisfying certain conditions based on an entire population.
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 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.
EXPON.DIST
The exponential distribution.
EXPONDIST
(EXPON.DIST) The exponential distribution.
F.DIST
The probability of getting less than or equal to a particular value in an f distribution (left tailed).
F.DIST.RT
The probability of getting less than or equal to a particular value in an f distribution (right tailed).
F.INV
The probability of getting greater than a particular value in an f distribution (left tailed).
F.INV.RT
The probability of getting greater than a particular value in an f distribution (right tailed).
F.TEST
The value from the f test.
FACT
The factorial of a number.
FACTDOUBLE
The double factorial of a number.
FALSE
The logical value False.
FDIST
(F.DIST) The probability of getting less than or equal to a particular value in an f distribution (no cumulative) (left tailed).
FIELDVALUE
(Office 365) The field data from a Stocks or Geography linked data type.
FILTER
(Office 365) The array of data in a range that satisfies multiple conditions.
FILTERXML
(2013) The specific data from the xml content by using xpath.
FIND
The position of a substring within a larger text string.
FINV
(F.INV) The probability of getting greater than a particular value in 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 (inc. 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 value from the f test.
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 of getting less than or equal to a particular value in a gamma distribution.
GAMMA.INV
The probability of getting greater than a particular value in a gamma distribution.
GAMMADIST
(GAMMA.DIST) The probability of getting less than or equal to a particular value in a gamma distribution.
GAMMAINV
(GAMMA.INV) The probability of getting greater than a particular value in 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.
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.
HYPERLINK
The hyperlink linked to a cell, document or webpage.
HYPGEOM.DIST
The probability of getting less than or equal to a particular value in a hyper geometric distribution (finite population).
HYPGEOMDIST
(HYPGEOM.DIST) The probability of getting less than or equal to a particular value in a hyper geometric distribution (finite population) (no cumulative).
IF
The value based on a condition you specify.
IFERROR
The value based on an error condition you specify.
IFNA
(2013) The value True or False depending if the value is #N/A.
IFS
(2019) The value based on multiple conditions you specify.
IMABS
The absolute value of a complex number.
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 text string of the contents of a given cell reference.
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 paid for a given period in a series of equal cash flows at regular intervals.
IRR
The interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
ISBLANK
The value True or False depending if the value is blank.
ISERR
The value True or False depending if the value is an error (not #N/A).
ISERROR
The value True or False depending if the value is an error.
ISEVEN
The value True or False depending if the value is an even number.
ISFORMULA
(2013) The value True or False depending if the cell contains a formula.
ISLOGICAL
The value True or False depending if the value is True or False.
ISNA
The value True or False depending if the value is #N/A.
ISNONTEXT
The value True or False depending if the value is non text.
ISNUMBER
The value 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 value True or False depending if the value is an odd number.
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 value True or False depending if the value is a cell reference.
ISTEXT
The value 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.
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.
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 probability of getting greater than a particular value in a lognormal distribution.
LOGNORM.DIST
The probability of getting less than or equal to a particular value in a lognormal distribution.
LOGNORM.INV
The probability of getting greater than a particular value in a lognormal distribution.
LOGNORMDIST
(LOGNORM.DIST) The probability of getting less than or equal to a particular value in a lognormal distribution (no 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.
MATCH
The position of a value in a list, table or cell range.
MAX
The largest value in a list or array of numbers.
MAXA
The largest value in a list or array of numbers (including logical values and text).
MAXIFS
(2019) The largest value in a list or array of numbers that satisfies multiple conditions.
MDETERM
The matrix determinant of an array.
MDURATION
The modified duration for a security that pays interest periodically.
MEDIAN
The median value in a list or array of numbers.
MID
The text string which is a substring of a given string.
MIN
The smallest value in a list or array of numbers.
MINA
The smallest value in a list or array of numbers (including logical values and text).
MINIFS
(2019) The smallest value in a list or array of numbers that satisfies multiple conditions.
MINUTE
The minute as an integer given a date serial number.
MINVERSE
The inverse matrix of an array.
MIRR
The internal rate of return 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 value that occurs most frequently in a list or array of numbers.
MODE.MULT
The array of most frequent or repetitive values.
MODE.SNGL
The value that occurs most frequently in a list or array of numbers.
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.
N
The value converted to a number.
NA
The error value #N/A.
NEGBINOM.DIST
The probability of getting less than or equal to a particular value in a negative binomial distribution.
NEGBINOMDIST
(NEGBINOM.DIST) The probability of getting less than or equal to a particular value in 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 of getting less than or equal to a particular value in a normal distribution.
NORM.INV
The x variable corresponding to less than a particular probability.
NORM.S.DIST
The probability of getting less than or equal to a particular value in a standard normal distribution.
NORM.S.INV
The x variable corresponding to less than a particular probability.
NORMDIST
(NORM.DIST) The probability of getting less than or equal to a particular value in a normal distribution.
NORMINV
(NORM.INV) The x variable corresponding to less than a particular probability.
NORMSDIST
(NORM.S.DIST) The probability of getting less than or equal to a particular value in a normal distribution (no cumulative).
NORMSINV
(NORM.S.INV) The x variable corresponding to less than a particular probability.
NOT
The opposite of a True or False value.
NOW
The serial number of the current system date and time.
NPER
The number of periods for an investment.
NPV
The 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 number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTILE.EXC
The number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INC
The number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTRANK
(PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive).
PERCENTRANK.EXC
The percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INC
The percentage rank of a value in an array of numbers (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).
PMT
The payment for a loan with constant payments and fixed interest.
POISSON
(POISSON.DIST) The probability of getting less than or equal to a particular value in a poisson distribution.
POISSON.DIST
The probability of getting less than or equal to a particular value in a poisson distribution.
POWER
The number raised to a given power.
PPMT
The fixed payment made in each period of a series of equal cash flows at regular intervals.
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 values in a range are between two limits.
PRODUCT
The product of all the numbers in a list 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.
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
(365 Insiders) 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 a list, table or cell range (in descending order) (equal ranking).
RANK.AVG
The rank of a value in a list, table or cell range (in descending order) (average ranking).
RANK.EQ
The rank of a value in a list, table or cell range (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.
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.
SEARCH
The 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
(365 Insiders) 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
(365 Insiders) 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 or array of numbers.
SORT
(365 Insiders) The array of data in a range that has been sorted.
SORTBY
(365 Insiders) The array of data in a range that has been sorted and satisfies multiple conditions.
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.
SUBSTITUTE
The text string after replacing instances of a substring.
SUBTOTAL
(AGGREGATE) The subtotal of values in a list, table or cell range.
SUM
The total value of the numbers in a list, table or cell range.
SUMIF
The total value of the numbers that satisfies one condition.
SUMIFS
The total value of the numbers that satisfies multiple conditions.
SUMPRODUCT
The sum of the product of one or more arrays of values.
SUMSQ
The sum of the squares of all the values in a list, table or cell range.
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 the first matching item.
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 of getting less than or equal to a particular value in a t distribution (left tailed).
T.DIST.2T
The percentage points probability for the t distribution.
T.DIST.RT
The probability of getting greater than a particular value in a t distribution (right tailed).
T.INV
The probability of getting greater than a particular value in a t distribution (left tailed)
T.INV.2T
The t value of the t distribution as a function of the probability and the degrees of freedom.
T.TEST
The probability associated with a t test.
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.
TEXTJOIN
(2019) The text string that is a concatenation of several strings (with delimiter).
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.
TODAY
The serial number representing today's date.
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 associated with a t test.
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
(365 Insiders) 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).
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.
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 of getting less than or equal to a particular value in a weibull distribution.
WEIBULL.DIST
The probability of getting less than or equal to a particular value in a weibull distribution.
WORKDAY
(WORKDAY.INTL) The serial number that is a given number of working days before or after a date.
WORKDAY.INTL
The serial number that is a given number of working days before or after a date.
XIRR
The interest rate for a series of unequal cash flows at irregular intervals.
XLOOKUP
(365 Insiders) The value in the same row after finding a matching value in any column.
XMATCH
(365 Insiders) The position of a value in a list, table or cell range.
XNPV
The present value for 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 two-tailed p-value of a z-test.
ZTEST
(Z.TEST) The two-tailed p-value of a z-test.

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