Supported Excel Formulas

You are here:

SpreadsheetWEB supports 459 of the most common Microsoft Excel functions. The table below lists all currently supported Excel formulas.

ABSReturns the absolute value of a number
ACCRINTReturns the accrued interest for a security that pays periodic interest
ACCRINTMReturns the accrued interest for a security that pays interest at maturity
ACOSReturns the arccosine of a number
ACOSHReturns the inverse hyperbolic cosine of a number
ACOT****Returns the principal value of the arccotangent, or inverse cotangent, of a number.
ACOTH****Returns the inverse hyperbolic cotangent of a number.
ADDRESSReturns a reference as text to a single cell in a worksheet
AGGREGATE*****Returns an aggregate in a list or database.
AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficient
AMORLINCReturns the depreciation for each accounting period
ANDReturns TRUE if all its arguments are TRUE
ARABIC****Converts a Roman numeral to an Arabic numeral.
AREASReturns the number of areas in a reference
ASCChanges full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
ASINReturns the arcsine of a number
ASINHReturns the inverse hyperbolic sine of a number
ATANReturns the arctangent of a number
ATAN2Returns the arctangent from x- and y-coordinates
ATANHReturns the inverse hyperbolic tangent of a number
AVEDEVReturns the average of the absolute deviations of data points from their mean
AVERAGEReturns the average of its arguments
AVERAGEAReturns the average of its arguments, including numbers, text, and logical values
AVERAGEIF**Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS**Returns the average (arithmetic mean) of all the cells in a range that meet a given set of conditions or criteria
BASE***The BASE function converts a number into a text representation with the given radix (base)
BESSELIReturns the modified Bessel function In(x)
BESSELJReturns the Bessel function Jn(x)
BESSELKReturns the modified Bessel function Kn(x)
BESSELYReturns the Bessel function Yn(x)
BETA.DIST****Returns the beta distribution.
BETA.INV****Returns the inverse of the beta cumulative probability density function (BETA.DIST)
BETADISTReturns the beta cumulative distribution function
BETAINVReturns the inverse of the cumulative distribution function for a specified beta distribution
BIN2DECConverts a binary number to decimal
BIN2HEXConverts a binary number to hexadecimal
BIN2OCTConverts a binary number to octal
BINOM.DIST****Returns the individual term binomial distribution probability.
BINOM.DIST.RANGE****Returns the probability of a trial result using a binomial distribution.
BINOM.INV****Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
BINOMDISTReturns the individual term binomial distribution probability
BITAND****Returns a bitwise ‘AND’ of two numbers
BITLSHIFT****Returns a number shifted left by the specified number of bits
BITOR****Returns a bitwise ‘OR’ of two numbers
BITRSHIFT****Returns a number shifted right by the specified number of bits
BITXOR****Returns a bitwise ‘XOR’ of two numbers
CEILINGRounds a number to the nearest integer or to the nearest multiple of significance
CEILING.MATH***The CEILING.MATH function rounds a number up to the nearest integer or to the nearest multiple of significance
CEILING.PRECISE****Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance
CELL*Returns information about the formatting, location, or contents of a cell
CHARReturns the character specified by the code number
CHIDISTReturns the one-tailed probability of the chi-squared distribution
CHIINVReturns the inverse of the one-tailed probability of the chi-squared distribution
CHISQ.DIST****Returns the chi-squared distribution
CHISQ.DIST.RT****Returns the right-tailed probability of the chi-squared distribution.
CHISQ.INV****Returns the inverse of the left-tailed probability of the chi-squared distribution
CHISQ.INV.RT****Returns the inverse of the right-tailed probability of the chi-squared distribution
CHISQ.TEST****Returns the test for independence. CHISQ.TEST returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom
CHITESTReturns the test for independence
CHOOSEChooses a value from a list of values
CLEANRemoves all nonprintable characters from text
CODEReturns a numeric code for the first character in a text string
COLUMNReturns the column number of a reference
COLUMNSReturns the number of columns in a reference
COMBINReturns the number of combinations for a given number of objects
COMBINA***The COMBINA function returns the number of combinations (with repetitions) for a given number of items
COMPLEXConverts real and imaginary coefficients into a complex number
CONCAT****Combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments
CONCATENATEJoins several text items into one text item
CONFIDENCE****Returns the confidence interval for a population mean, using a normal distribution
CONFIDENCE.NORM****Returns the confidence interval for a population mean, using a normal distribution
CONFIDENCE.T****Returns the confidence interval for a population mean, using a Student’s t distribution
CONVERTConverts a number from one measurement system to another
CORRELReturns the correlation coefficient between two data sets
COSReturns the cosine of a number
COSHReturns the hyperbolic cosine of a number
COT****Return the cotangent of an angle specified in radians
COTH****Return the hyperbolic cotangent of a hyperbolic angle
COUNTCounts how many numbers are in the list of arguments
COUNTACounts how many values are in the list of arguments
COUNTBLANKCounts the number of blank cells within a range
COUNTIF**Counts the number of cells within a range that meet the given condition
COUNTIFS**Counts the number of cells within a range that meet the given conditions or criteria
COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement date
COUPDAYSReturns the number of days in the coupon period that contains the settlement date
COUPDAYSNCReturns the number of days from the settlement date to the next coupon date
COUPNCDReturns the next coupon date after the settlement date
COUPNUMReturns the number of coupons payable between the settlement date and maturity date
COUPPCDReturns the previous coupon date before the settlement date
COVARReturns covariance, the average of the products of paired deviations
COVARIANCE.P****Returns population covariance, the average of the products of deviations for each data point pair in two data sets
COVARIANCE.S****Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets
CRITBINOMReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
CSC****Returns the cosecant of an angle specified in radians
CSCH****Return the hyperbolic cosecant of an angle specified in radians
CUMIPMTReturns the cumulative interest paid between two periods
CUMPRINCReturns the cumulative principal paid on a loan between two periods
DATEReturns the serial number of a particular date
DATEDIFCalculates the number of days, months, or years between two dates
DATEVALUEConverts a date in the form of text to a serial number
DAVERAGEAverages the values in a column of a list or database that match conditions you specify
DAYConverts a serial number to a day of the month
DAYS***DAYS function returns the number of days between two dates
DAYS360Calculates the number of days between two dates based on a 360-day year
DBReturns the depreciation of an asset for a specified period using the fixed-declining balance method
DBCS****Converts half-width (single-byte) letters within a character string to full-width (double-byte) characters
DCOUNTCounts the cells that contain numbers in a column of a list or database that match conditions that you specify
DCOUNTA*****The COUNTA counts the nonblank cells in a field (column) of records in a list or database that match conditions that you specify.
DDBReturns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify
DEC2BINConverts a decimal number to binary
DEC2HEXConverts a decimal number to hexadecimal
DEC2OCTConverts a decimal number to octal
DECIMAL***DECIMAL function converts a text representation of a number in a given base into a decimal number.
DEGREESConverts radians to degrees
DELTATests whether two values are equal
DEVSQReturns the sum of squares of deviations
DGETExtracts a single value from a column of a list or database that matches conditions that you specify
DISCReturns the discount rate for a security
DMAXReturns the largest number in a column of a list or database that matches conditions you that specify
DMINReturns the smallest number in a column of a list or database that matches conditions that you specify
DOLLARConverts a number to text, using the $ (dollar) currency format
DOLLARDEConverts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
DOLLARFRConverts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
DPRODUCTMultiplies the values in a column of a list or database that match conditions that you specify
DSTDEVEstimates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify
DSTDEVPCalculates the standard deviation of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify
DSUMAdds the numbers in a column of a list or database that match conditions that you specify
DURATIONReturns the annual duration of a security with periodic interest payments
DVAREstimates the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify
DVARPCalculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify
EDATEReturns the serial number of the date that is the indicated number of months before or after the start date
EFFECTReturns the effective annual interest rate
EOMONTHReturns the serial number of the last day of the month before or after a specified number of months
ERF**Returns the error function
ERF.PRECISE****Returns the error function
ERFCReturns the complementary error function
ERFC.PRECISE****Returns the error function
ERROR.TYPEReturns a number corresponding to an error type
EVENRounds a number up to the nearest even integer
EXACTChecks to see if two text values are identical
EXPReturns e raised to the power of a given number
EXPON.DIST****Returns the error function.
EXPONDIST**Returns the exponential distribution
F.DIST*****Returns the F probability distribution.
F.DIST.RT*****Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets.
F.INV*****Returns the inverse of the F probability distribution.
F.INV.RT*****Returns the inverse of the (right-tailed) F probability distribution.
F.TEST*****Returns the result of an F-test, the two-tailed probability that the variances in array1 and array2 are not significantly different.
FACTReturns the factorial of a number
FACTDOUBLE**Returns the double factorial of a number
FALSEReturns the logical value FALSE
FDISTConverts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation)
FINDFinds one text value within another (case-sensitive)
FINDBFinds one text value within another (case-sensitive). Intended for use with languages that use the double-byte character set.
FINVReturns the inverse of the F probability distribution
FISHERReturns the Fisher transformation
FISHERINVReturns the inverse of the Fisher transformation
FIXEDFormats a number as text with a fixed number of decimals
FLOORRounds a number down, toward zero
FLOOR.MATH****Round a number down to the nearest integer or to the nearest multiple of significance.
FLOOR.PRECISE****Returns a number that is rounded down to the nearest integer or to the nearest multiple of significance.
FORECASTReturns a value along a linear trend
FORECAST.ETS*****Calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.
FORECAST.ETS.CONFINT*****Returns a confidence interval for the forecast value at the specified target date.
FORECAST.ETS.SEASONALITY*****Returns the length of the repetitive pattern Excel detects for the specified time series.
FORECAST.ETS.STAT*****Returns a statistical value as a result of time series forecasting.
FORECAST.LINEAR*****Calculates, or predicts, a future value by using existing values.
FORMULATEXT****Returns a formula as a string.
FREQUENCYReturns the inverse of the F probability distribution
FTESTReturns the inverse of the F probability distribution
FVReturns the future value of an investment
FVSCHEDULEReturns the future value of an initial principal after applying a series of compound interest rates
GAMMA*****Return the gamma function value.
GAMMA.DIST*****Returns the gamma distribution.
GAMMA.INV*****Returns the inverse of the gamma cumulative distribution.
GAMMADISTReturns the gamma distribution
GAMMAINVReturns the inverse of the gamma cumulative distribution
GAMMALNReturns the natural logarithm of the gamma function, Γ(x)
GAMMALN.PRECISE*****Returns the natural logarithm of the gamma function, Γ(x).
GAUSS*****Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean.
GCDReturns the greatest common divisor
GEOMEANReturns the geometric mean
GESTEPTests whether a number is greater than a threshold value
GROWTH*Returns values along an exponential trend
HARMEANReturns the harmonic mean
HEX2BINConverts a hexadecimal number to binary
HEX2DECConverts a hexadecimal number to decimal
HEX2OCTConverts a hexadecimal number to octal
HLOOKUP**Looks in the top row of an array and returns the value of the indicated cell
HOURConverts a serial number to an hour
HYPERLINK*Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
HYPGEOM.DIST****Returns the hypergeometric distribution.
HYPGEOMDIST*Returns the hypergeometric distribution
IFSpecifies a logical test to perform
IFERROR****Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
IFNA***IFNA formula returns the value you specify if the formula returns the #N/A error value; otherwise returns the result of the formula.
IFS****The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
IMABSReturns the absolute value (modulus) of a complex number
IMAGINARYReturns the imaginary coefficient of a complex number
IMARGUMENTReturns the argument theta, an angle expressed in radians
IMCONJUGATEReturns the complex conjugate of a complex number
IMCOS**Returns the cosine of a complex number
IMCOSH****Returns the hyperbolic cosine of a complex number in x+yi or x+yj text format.
IMCOT****Returns the cotangent of a complex number in x+yi or x+yj text format.
IMCSC****Returns the cosecant of a complex number in x+yi or x+yj text format.
IMCSCH****Returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format.
IMDIV**Returns the quotient of two complex numbers
IMEXP**Returns the exponential of a complex number
IMLN**Returns the natural logarithm of a complex number
IMLOG10**Returns the base-10 logarithm of a complex number
IMLOG2**Returns the base-2 logarithm of a complex number
IMPOWER**Returns a complex number raised to an integer power
IMPRODUCT**Returns the product of two complex numbers
IMREAL**Returns the real coefficient of a complex number
IMSEC****Returns the secant of a complex number in x+yi or x+yj text format.
IMSECH****Returns the hyperbolic secant of a complex number in x+yi or x+yj text format.
IMSIN**Returns the sine of a complex number
IMSINH****Returns the hyperbolic sine of a complex number in x+yi or x+yj text format.
IMSQRT**Returns the square root of a complex number
IMSUBReturns the difference between two complex numbers
IMSUMReturns the sum of complex numbers
IMTAN****Returns the tangent of a complex number in x+yi or x+yj text format.
INDEX**Uses an index to choose a value from a reference or array
INDIRECT*Returns a reference indicated by a text value
INFOReturns information about the current operating environment
INTRounds a number down to the nearest integer
INTERCEPTReturns the intercept of the linear regression line
INTRATEReturns the interest rate for a fully invested security
IPMTReturns the interest payment for an investment for a given period
IRRReturns the internal rate of return for a series of cash flows
ISBLANKReturns TRUE if the value is blank
ISERRReturns TRUE if the value is any error value except #N/A
ISERRORReturns TRUE if the value is any error value
ISEVENReturns TRUE if the number is even
ISFORMULA****Checks whether there is a reference to a cell that contains a formula, and returns TRUE or FALSE.
ISLOGICALReturns TRUE if the value is a logical value
ISNAReturns TRUE if the value is the #N/A error value
ISNONTEXTReturns TRUE if the value is not text
ISNUMBER**Returns TRUE if the value is a number
ISO.CEILING***Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance
ISODDReturns TRUE if the number is odd
ISOWEEKNUM****Returns number of the ISO week number of the year for a given date.
ISPMTCalculates the interest paid during a specific period of an investment
ISREFReturns TRUE if the value is a reference
ISTEXTReturns TRUE if the value is text
KURTReturns the kurtosis of a data set
LARGE**Returns the k-th largest value in a data set
LCMReturns the least common multiple
LEFTReturns the leftmost characters from a text value
LEFTBReturns the leftmost characters from a text value. Intended for use with languages that use the double-byte character set.
LENReturns the number of characters in a text string
LENBReturns the number of characters in a text string. Intended for use with languages that use the double-byte character set.
LINEST**Returns the parameters of a linear trend
LNReturns the natural logarithm of a number
LOGReturns the logarithm of a number to a specified base
LOG10Returns the base-10 logarithm of a number
LOGEST*Returns the parameters of a exponential trend
LOGINVReturns the inverse of the lognormal distribution
LOGNORM.DIST****Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev.
LOGNORM.INV****Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev
LOGNORMDISTReturns the cumulative lognormal distribution
LOOKUP**Looks up values in a vector or array
LOWERConverts text to lowercase
MATCHLooks up values in a reference or array
MAX**Returns the maximum value in a list of arguments
MAXA**Returns the maximum value in a list of arguments, including numbers, text, and logical values
MAXIFS*****The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria.
MDETERMReturns the matrix determinant of an array
MDURATIONReturns the Macauley modified duration for a security with an assumed par value of $100
MEDIANReturns the median of the given numbers
MIDReturns a specific number of characters from a text string starting at the position you specify
MIDBReturns a specific number of characters from a text string starting at the position you specify. Intended for use with languages that use the double-byte character set.
MIN**Returns the minimum value in a list of arguments
MINA**Returns the smallest value in a list of arguments, including numbers, text, and logical values
MINIFS*****The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.
MINUTEConverts a serial number to a minute
MINVERSEReturns the matrix inverse of an array
MIRRReturns the internal rate of return where positive and negative cash flows are financed at different rates
MMULTReturns the matrix product of two arrays
MODReturns the remainder from division
MODEReturns the most common value in a data set
MODE.MULT****Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
MODE.SNGL****Returns the most frequently occurring, or repetitive, value in an array or range of data.
MONTHConverts a serial number to a month
MROUNDReturns a number rounded to the desired multiple
MULTINOMIALReturns the multinomial of a set of numbers
MUNIT****Returns the unit matrix for the specified dimension.
NReturns a value converted to a number
NAReturns the error value #N/A
NEGBINOM.DIST****Returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with Probability_s probability of a success.
NEGBINOMDISTReturns the negative binomial distribution
NETWORKDAYSReturns the number of whole workdays between two dates
NETWORKDAYS.INTL****Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.
NOMINALReturns the annual nominal interest rate
NORM.DIST****Returns the normal distribution for the specified mean and standard deviation.
NORM.INV****Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORM.S.DIST****Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
NORM.S.INV****Returns the inverse of the standard normal cumulative distribution.
NORMDISTReturns the normal cumulative distribution
NORMINVReturns the inverse of the normal cumulative distribution
NORMSDISTReturns the standard normal cumulative distribution
NORMSINVReturns the inverse of the standard normal cumulative distribution
NOTReverses the logic of its argument
NOWReturns the serial number of the current date and time
NPERReturns the number of periods for an investment
NPVReturns the net present value of an investment based on a series of periodic cash flows and a discount rate
NUMBERVALUE***Converts text to a number, in a locale-independent way.
OCT2BINConverts an octal number to binary
OCT2DECConverts an octal number to decimal
OCT2HEXConverts an octal number to hexadecimal
ODDRounds a number up to the nearest odd integer
ODDFPRICEReturns the price per $100 face value of a security with an odd first period
ODDFYIELDReturns the yield of a security with an odd first period
ODDLPRICEReturns the price per $100 face value of a security with an odd last period
ODDLYIELDReturns the yield of a security with an odd last period
OFFSET**Returns a reference offset from a given reference
ORReturns TRUE if any argument is TRUE
PDURATION*****Returns the number of periods required by an investment to reach a specified value.
PEARSONReturns the Pearson product moment correlation coefficient
PERCENTILEReturns the k-th percentile of values in a range
PERCENTILE.EXC****Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INC****Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
PERCENTRANKReturns the percentage rank of a value in a data set
PERCENTRANK.EXC****Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
PERCENTRANK.INC****Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set.
PERMUTReturns the number of permutations for a given number of objects
PERMUTATIONA*****Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.
PHI*****Returns the value of the density function for a standard normal distribution.
PIReturns the value of pi
PMTReturns the periodic payment of an annuity
POISSONReturns the Poisson distribution
POISSON.DIST****Returns the Poisson distribution.
POWERReturns the result of a number raised to a power
PPMTReturns the payment on the principal for an investment for a given period
PRICEReturns the price per $100 face value of a security that pays periodic interest
PRICEDISCReturns the price per $100 face value of a discounted security
PRICEMAT*Returns the price per $100 face value of a security that pays interest at maturity
PROBReturns the probability that values in a range are between two limits
PRODUCTMultiplies its arguments
PROPERCapitalizes the first letter in each word of a text value
PVReturns the present value of an investment
QUARTILEReturns the quartile of a data set
QUARTILE.EXC****Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
QUARTILE.INC****Returns the quartile of a data set, based on percentile values from 0..1, inclusive.
QUOTIENTReturns the integer portion of a division
RADIANSConverts degrees to radians
RANDReturns a random number between 0 and 1
RANDBETWEENReturns a random integer number between the numbers you specify.
RANKReturns the rank of a number in a list of numbers
RANK.AVG***Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned
RANK.EQ***Returns the rank of a number in a list of numbers
RATE**Returns the interest rate per period of an annuity
RECEIVEDReturns the amount received at maturity for a fully invested security
REPLACEReplaces characters within text
REPLACEBReplaces characters within text. Intended for use with languages that use the double-byte character set.
REPTRepeats text a given number of times
RIGHTReturns the rightmost characters from a text value
RIGHTBReturns the rightmost characters from a text value. Intended for use with languages that use the double-byte character set.
ROMAN**Converts an arabic numeral to roman, as text
ROUNDRounds a number to a specified number of digits
ROUNDDOWNRounds a number down, toward zero
ROUNDUPRounds a number up, away from zero
ROWReturns the row number of a reference
ROWSReturns the number of rows in a reference
RRI*****Returns an equivalent interest rate for the growth of an investment.
RSQReturns the square of the Pearson product moment correlation coefficient
SEARCHFinds one text value within another (not case-sensitive)
SEARCHBFinds one text value within another (not case-sensitive). Intended for use with languages that use the double-byte character set.
SEC***The SEC function returns the secant of an angle
SECH****Returns the hyperbolic secant of an angle.
SECONDConverts a serial number to a second
SERIESSUMReturns the confidence interval for a population mean
SHEET*****Returns the sheet number of the reference sheet.
SHEETS*****Returns the number of sheets in a reference.
SIGNReturns the sign of a number
SINReturns the sine of the given angle
SINHReturns the hyperbolic sine of a number
SKEWReturns the skewness of a distribution
SKEW.P*****Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean.
SLNReturns the straight-line depreciation of an asset for one period
SLOPEReturns the slope of the linear regression line
SMALLReturns the k-th smallest value in a data set
SQRTReturns a positive square root
SQRTPIReturns the square root of (number * pi)
STANDARDIZEReturns a normalized value
STDEVEstimates standard deviation based on a sample
STDEV.P****Calculates standard deviation based on the entire population given as arguments.
STDEV.S****Estimates standard deviation based on a sample (ignores logical values and text in the sample).
STDEVAEstimates standard deviation based on a sample, including numbers, text, and logical values
STDEVPCalculates standard deviation based on the entire population
STDEVPACalculates standard deviation based on the entire population, including numbers, text, and logical values
STEYXReturns the standard error of the predicted y-value for each x in the regression
SUBSTITUTESubstitutes new text for old text in a text string
SUBTOTALReturns a subtotal in a list or database
SUMAdds its arguments
SUMIF**Adds the cells specified by a given criteria
SUMIFS**Adds the cells specified by a given criteria
SUMPRODUCT**Returns the sum of the products of corresponding array components
SUMSQReturns the sum of the squares of the arguments
SUMX2MY2Returns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2Returns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2Returns the sum of squares of differences of corresponding values in two arrays
SWITCH****Evaluates one value against a list of values, and returns the result corresponding to the first matching value.
SYDReturns the sum-of-years’ digits depreciation of an asset for a specified period
TConverts its arguments to text
T.DIST*****Returns the Student’s left-tailed t-distribution.
T.DIST.2T*****Returns the two-tailed Student’s t-distribution.
T.DIST.RT*****Returns the right-tailed Student’s t-distribution.
T.INV*****Returns the left-tailed inverse of the Student’s t-distribution.
T.INV.2T*****Returns the two-tailed inverse of the Student’s t-distribution.
T.TEST*****Returns the probability associated with a Student’s t-Test.
TANReturns the tangent of a number
TANHReturns the hyperbolic tangent of a number
TBILLEQReturns the bond-equivalent yield for a Treasury bill
TBILLPRICEReturns the price per $100 face value for a Treasury bill
TBILLYIELDReturns the yield for a Treasury bill
TDISTReturns the Student’s t-distribution
TEXT**Formats a number and converts it to text
TEXTJOIN***Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined
TIMEReturns the serial number of a particular time
TIMEVALUEConverts a time in the form of text to a serial number
TINVReturns the inverse of the Student’s t-distribution
TODAYReturns the serial number of today’s date
TRANSPOSEReturns the transpose of an array
TREND***Returns values along a linear trend
TRIMRemoves spaces from text
TRIMMEAN*Returns the mean of the interior of a data set
TRUEReturns the logical value TRUE
TRUNCTruncates a number to an integer
TTESTReturns the probability associated with a Student’s t-test
TYPEReturns a number indicating the data type of a value
UNICHAR****Returns the Unicode character that is referenced by the given numeric value.
UNICODE****Returns the number (code point) corresponding to the first character of the text.
UPPERConverts text to uppercase
VALUEConverts a text argument to a number
VAREstimates variance based on a sample
VAR.P****Calculates variance based on the entire population (ignores logical values and text in the population).
VAR.S****Estimates variance based on a sample (ignores logical values and text in the sample).
VARAEstimates variance based on a sample, including numbers, text, and logical values
VARPCalculates variance based on the entire population
VARPACalculates variance based on the entire population, including numbers, text, and logical values
VDBReturns the depreciation of an asset for a specified or partial period using a declining balance method
VLOOKUP**Looks in the first column of an array and moves across the row to return the value of a cell
WEEKDAYConverts a serial number to a day of the week
WEEKNUMConverts a serial number to a number representing where the week falls numerically with a year
WEIBULL*Returns the Weibull distribution
WEIBULL.DIST****Returns the Weibull distribution.
WORKDAYReturns the serial number of the date before or after a specified number of workdays
WORKDAY.INTL****Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters.
XIRRReturns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XNPVReturns the net present value for a schedule of cash flows that is not necessarily periodic
XOR****Returns a logical Exclusive Or of all arguments.
YEARConverts a serial number to a year
YEARFRACReturns the year fraction representing the number of whole days between start_date and end_date
YIELDReturns the yield on a security that pays periodic interest
YIELDDISCReturns the annual yield for a discounted security; for example, a Treasury bill
YIELDMATReturns the annual yield of a security that pays interest at maturity
Z.TEST*****Estimates variance based on a sample (ignores logical values and text in the sample).
ZTESTReturns the one-tailed probability-value of a z-test

*: Limited support. See Formulas with Limited Support for details

**: This formula is fully supported in version 6.0 and up. For older versions of the software, please use the recommended workaround in Formulas with Limited Support.

***: This formula is fully supported in version 6.0 and up.

****: This formula is fully supported in version 6.1 and up.

*****: This formula is fully supported in version 6.2 and up.