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.
AGGREGATE(2010) The 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 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).
AVERAGEIF(2007) The arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFS(2007) The 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.DIST(2010) The probability of getting less than or equal to a particular value in a beta distribution.
BETA.INV(2010) 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.
BIN2DECThe number converted from binary to decimal.
BIN2HEXThe number converted from binary to hexadecimal.
BIN2OCTThe number converted from binary to octal.
BINOM.DIST(2010) 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(2010) 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.
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 number.
CHIDIST(CHISQ.DIST.RT) The probability of getting less than or equal to a particular value in a chi-squared distribution.
CHIINV(CHISQ.INV.RT) The probability of getting greater than a particular value in a chi-squared distribution.
CHISQ.DIST(2010) The left tailed probability of the chi-squared distribution.
CHISQ.DIST.RT(2010) The right tailed probability of the chi-squared distribution.
CHISQ.INV(2010) The inverse of the left tailed probability of the chi-squared distribution.
CHISQ.INV.RT(2010) The inverse of the right tailed probability of the chi-squared distribution.
CHISQ.TEST(2010) The value from the chi-squared distribution.
CHITEST(CHISQ.TEST) The value from the chi-squared distribution.
CHOOSEThe value from a list of values, based on an index number.
CLEANThe text string with all the non-printable characters removed.
CODEThe ANSI number for the first character in a text string.
COLUMNThe column number of the 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(2016 Jan) 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(2010) The confidence interval for a population mean.
CONFIDENCE.T(2010) The 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.
COUNTIFS(2007) The 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.P(2010) The covariance based on an entire population.
COVARIANCE.S(2010) 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(2007) The name of a key performance indicator.
CUBEMEMBER(2007) The member or tuple from a cube.
CUBESET(2007) The calculated members returns from a cube.
CUBESETCOUNT(2007) The number of items in a set.
CUBEVALUE(2007) The 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.
DATEDIFThe number of units between two dates.
DATEVALUEThe serial number that represents a given date in text format.
DAVERAGEThe arithmetic mean on 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 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 squares of deviations of data points from their sample 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 values in a database column satisfying certain conditions.
DSTDEVPThe standard deviation of values in a database column satisfying certain conditions.
DSUMThe sum of values in a database column satisfying certain conditions.
DURATIONThe annual duration of a security that pays interest periodically.
DVARThe variance in a database column satisfying certain conditions based on a sample.
DVARPThe variance in a database column satisfying certain conditions based on an entire population.
EDATEThe serial number that is a given 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.PRECISE(2010) 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(2010) The 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.DIST(2010) The exponential distribution.
EXPONDIST(EXPON.DIST) The exponential distribution.
F.DIST(2010) The probability of getting less than or equal to a particular value in an f distribution.
F.DIST.RT(2010) The probability of getting less than or equal to a particular value in an f distribution.
F.INV(2010) The probability of getting greater than a particular value in an f distribution.
F.INV.RT(2010) The probability of getting greater than a particular value in an f distribution.
F.TEST(2010) The 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).
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.
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.DIST(2010) The probability of getting less than or equal to a particular value in a gamma distribution.
GAMMA.INV(2010) 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(2010) The 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 integers.
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 a row that matches a value in the top row of a table.
HOURThe hour as an integer given a date serial number.
HYPERLINKThe hyperlink linked to a cell, document or webpage.
HYPGEOM.DIST(2010) 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).
IFThe value based on a condition you specify.
IFERROR(2007) The value based on an error condition you specify.
IFNA(2013) The value True or False depending if the value is #N/A.
IFS(2016 Jan) 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.
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.
JISThe text string with all the characters converted to double byte characters.
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 integers.
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 a given 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.DIST(2010) The probability of getting less than or equal to a particular value in a lognormal distribution.
LOGNORM.INV(2010) 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).
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 lower case.
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(2016 Jan) 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(2016 Jan) 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 (with reinvestment).
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.MULT(2010) The array of most frequent or repetitive values.
MODE.SNGL(2010) The 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.DIST(2010) 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(2010) The 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.DIST(2010) The probability of getting less than or equal to a particular value in a normal distribution.
NORM.INV(2010) The x variable corresponding to less than a particular probability.
NORM.S.DIST(2010) The probability of getting less than or equal to a particular value in a standard normal distribution.
NORM.S.INV(2010) 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.
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 text to number in a locale independent manner.
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 cell value which is an offset from a given cell reference.
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.EXC(2010) The number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INC(2010) 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(2010) The percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INC(2010) The 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.DIST(2010) The 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.
QUARTILE.EXC(2010) The quartile of a data set (exclusive).
QUARTILE.INC(2010) The quartile of a data set.
QUOTIENTThe integer portion after division.
RADIANSThe number of radians given the number of degrees.
RANDThe random number >=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).
RANK.AVG(2010) The rank of a value in a list, table or cell range (in descending order).
RANK.EQ(2010) The rank of a value in a list, table or cell range (in descending order).
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 with a number of characters replaced.
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 the 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 given a date serial number.
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.
SINHThe hyperbolic sine of a number.
SKEWThe number representing the skewness of a distribution.
SKEW.P(2013) The skewness of a distribution based on a 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.
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.P(2010) The standard deviation based on an entire population.
STDEV.S(2010) The 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 with a substring substituted for another 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.
SUMIFS(2007) The 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(2016 Jan) 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.DIST(2010) The t distribution.
T.DIST.2T(2010) The percentage points probability for the t distribution.
T.DIST.RT(2010) The percentage points probability for the t distribution.
T.INV(2010) The t-value of the t distribution as a function of the probability.
T.INV.2T(2010) The t value of the t distribution as a function of the probability and the degrees of freedom.
T.TEST(2010) The 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 text string of a number in a particular format.
TEXTJOIN(2016 Jan) The text string that is a concatenation of several strings (with delimiter).
TIMEThe time as a decimal given the hour, minute and second.
TIMEVALUEThe time as a decimal returned as text given a date serial number.
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 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 unicode character that is references by the given numeric value.
UNICODE(2013) The number that corresponds to the first character of the text.
UPPERThe text string with all the characters converted to upper case.
VALUEThe number that a text string represents.
VAR(VAR.S) The variance based on a sample.
VAR.P(2010) The variance based on an entire population.
VAR.S(2010) The 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 a column that matches a value in the first column of a table.
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.DIST(2010) 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(2010) The 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.
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.TEST(2010) The two-tailed p-value of a z-test.
ZTEST(Z.TEST) The two-tailed p-value of a z-test.

© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited