Alphabetical A - M

ABSThe absolute value or a number without its sign.
ACCRINTThe accrued interest for a security that pays interest periodically.
ACCRINTMThe accrued interest for a security that pays interest at maturity.
ACOSThe arc-cosine of a number.
ACOSHThe hyperbolic arc-cosine of a number.
ACOT(2013) The arc-cotangent of a number.
ACOTH(2013) The hyperbolic arc-cotangent of a number.
ADDRESSThe cell reference given a row and column number.
AGGREGATEThe aggregate of values in a list, table or cell range.
AMORDEGRCThe depreciation of an asset in a single period (straight-line, implicit coefficient).
AMORLINCThe depreciation of an asset in a single period (straight-line).
ANDThe logical AND for any number of arguments.
ARABIC(2013) The number converted from roman to arabic.
AREASThe number of areas in a cell range or reference.
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 logical test that is either True or False.
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 True or False conditions.
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.
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 logical test that is either True or False.
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 True or False conditions.
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.

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