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
ACOT4Returns the principal value of the arccotangent, or inverse cotangent of a number.
ACOTH4Returns the inverse hyperbolic cotangent of a number.
ADDRESSReturns a reference as text to a single cell in a worksheet
AGGREGATE5Returns 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
ARABIC4Converts 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
AVERAGEIF2Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS2Returns the average (arithmetic mean) of all the cells in a range that meet a given set of conditions or criteria
BASE3The 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.DIST4Returns the beta distribution.
BETA.INV4Returns 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.DIST4Returns the individual term binomial distribution probability.
BINOM.DIST.RANGE4Returns the probability of a trial result using a binomial distribution.
BINOM.INV4Returns 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
BITAND4Returns a bitwise ‘AND’ of two numbers
BITLSHIFT4Returns a number shifted left by the specified number of bits
BITOR4Returns a bitwise ‘OR’ of two numbers
BITRSHIFT4Returns a number shifted right by the specified number of bits
BITXOR4Returns a bitwise ‘XOR’ of two numbers
CEILINGRounds a number to the nearest integer or to the nearest multiple of significance
CEILING.MATH3The CEILING.MATH function rounds a number up to the nearest integer or to the nearest multiple of significance
CEILING.PRECISE4Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance
CELL1Returns 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.DIST4Returns the chi-squared distribution
CHISQ.DIST.RT4Returns the right-tailed probability of the chi-squared distribution.
CHISQ.INV4Returns the inverse of the left-tailed probability of the chi-squared distribution
CHISQ.INV.RT4Returns the inverse of the right-tailed probability of the chi-squared distribution
CHISQ.TEST4Returns 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
COMBINA3The COMBINA function returns the number of combinations (with repetitions) for a given number of items
COMPLEXConverts real and imaginary coefficients into a complex number
CONCAT4Combines 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
CONFIDENCE4Returns the confidence interval for a population mean, using a normal distribution
CONFIDENCE.NORM4Returns the confidence interval for a population mean, using a normal distribution
CONFIDENCE.T4Returns the confidence interval for a population mean, using a Student’s t distribution
CONVERT1Converts 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
COT4Return the cotangent of an angle specified in radians
COTH4Return 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
COUNTIF2Counts the number of cells within a range that meet the given condition
COUNTIFS2Counts 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.P4Returns population covariance, the average of the products of deviations for each data point pair in two data sets
COVARIANCE.S4Returns 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
CSC4Returns the cosecant of an angle specified in radians
CSCH4Return 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
DAYS3DAYS 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
DBCS4Converts 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
DCOUNTA5The 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
DECIMAL3DECIMAL 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
ERF2Returns the error function
ERF.PRECISE4Returns the error function
ERFCReturns the complementary error function
ERFC.PRECISE4Returns 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.DIST4Returns the error function.
EXPONDIST2Returns the exponential distribution
F.DIST5Returns the F probability distribution.
F.DIST.RT5Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets.
F.INV5Returns the inverse of the F probability distribution.
F.INV.RT5Returns the inverse of the (right-tailed) F probability distribution.
F.TEST5Returns 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
FACTDOUBLE2Returns 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)
FILTER6Filters a range or array by a given condition.
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.MATH4Round a number down to the nearest integer or to the nearest multiple of significance.
FLOOR.PRECISE4Returns 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.ETS5Calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.
FORECAST.ETS.CONFINT5Returns a confidence interval for the forecast value at the specified target date.
FORECAST.ETS.SEASONALITY5Returns the length of the repetitive pattern Excel detects for the specified time series.
FORECAST.ETS.STAT5Returns a statistical value as a result of time series forecasting.
FORECAST.LINEAR5Calculates, or predicts, a future value by using existing values.
FORMULATEXT4Returns 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
GAMMA5Return the gamma function value.
GAMMA.DIST5Returns the gamma distribution.
GAMMA.INV5Returns 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.PRECISE5Returns the natural logarithm of the gamma function, Γ(x).
GAUSS5Calculates 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
GROWTH1Returns 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
HLOOKUP2Looks in the top row of an array and returns the value of the indicated cell
HOURConverts a serial number to an hour
HYPERLINK1Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
HYPGEOM.DIST4Returns the hypergeometric distribution.
HYPGEOMDIST1Returns the hypergeometric distribution
IFSpecifies a logical test to perform
IFERROR4Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
IFNA3IFNA formula returns the value you specify if the formula returns the #N/A error value; otherwise returns the result of the formula.
IFS4The 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
IMCOS2Returns the cosine of a complex number
IMCOSH4Returns the hyperbolic cosine of a complex number in x+yi or x+yj text format.
IMCOT4Returns the cotangent of a complex number in x+yi or x+yj text format.
IMCSC4Returns the cosecant of a complex number in x+yi or x+yj text format.
IMCSCH4Returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format.
IMDIV2Returns the quotient of two complex numbers
IMEXP2Returns the exponential of a complex number
IMLN2Returns the natural logarithm of a complex number
IMLOG102Returns the base-10 logarithm of a complex number
IMLOG22Returns the base-2 logarithm of a complex number
IMPOWER2Returns a complex number raised to an integer power
IMPRODUCT2Returns the product of two complex numbers
IMREAL2Returns the real coefficient of a complex number
IMSEC4Returns the secant of a complex number in x+yi or x+yj text format.
IMSECH4Returns the hyperbolic secant of a complex number in x+yi or x+yj text format.
IMSIN2Returns the sine of a complex number
IMSINH4Returns the hyperbolic sine of a complex number in x+yi or x+yj text format.
IMSQRT2Returns the square root of a complex number
IMSUBReturns the difference between two complex numbers
IMSUMReturns the sum of complex numbers
IMTAN4Returns the tangent of a complex number in x+yi or x+yj text format.
INDEX2Uses an index to choose a value from a reference or array
INDIRECT1Returns 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
ISFORMULA4Checks 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
ISNUMBER2Returns TRUE if the value is a number
ISO.CEILING3Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance
ISODDReturns TRUE if the number is odd
ISOWEEKNUM4Returns 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
LARGE2Returns 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.
LINEST2Returns 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
LOGEST1Returns the parameters of a exponential trend
LOGINVReturns the inverse of the lognormal distribution
LOGNORM.DIST4Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev.
LOGNORM.INV4Returns 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
LOOKUP2Looks up values in a vector or array
LOWERConverts text to lowercase
MATCHLooks up values in a reference or array
MAX2Returns the maximum value in a list of arguments
MAXA2Returns the maximum value in a list of arguments, including numbers, text, and logical values
MAXIFS5The 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.
MIN2Returns the minimum value in a list of arguments
MINA2Returns the smallest value in a list of arguments, including numbers, text, and logical values
MINIFS5The 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.MULT4Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
MODE.SNGL4Returns 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
MUNIT4Returns the unit matrix for the specified dimension.
NReturns a value converted to a number
NAReturns the error value #N/A
NEGBINOM.DIST4Returns 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.INTL4Returns 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.DIST4Returns the normal distribution for the specified mean and standard deviation.
NORM.INV4Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORM.S.DIST4Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
NORM.S.INV4Returns 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
NUMBERVALUE3Converts 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
OFFSET2Returns a reference offset from a given reference
ORReturns TRUE if any argument is TRUE
PDURATION5Returns 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.EXC4Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INC4Returns 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.EXC4Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
PERCENTRANK.INC4Returns 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
PERMUTATIONA5Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.
PHI5Returns 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.DIST4Returns 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
PRICEMAT1Returns 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.EXC4Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
QUARTILE.INC4Returns 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
RANDARRAY6Creates an array of randomly generated numbers
RANDBETWEENReturns a random integer number between the numbers you specify.
RANKReturns the rank of a number in a list of numbers
RANK.AVG3Returns 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.EQ3Returns the rank of a number in a list of numbers
RATE2Returns 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.
ROMAN2Converts 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
RRI5Returns 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.
SEC3The SEC function returns the secant of an angle
SECH4Returns the hyperbolic secant of an angle.
SECONDConverts a serial number to a second
SEQUENCE6Generates a list of sequential numbers in the form of an array or range.
SERIESSUMReturns the confidence interval for a population mean
SHEET5Returns the sheet number of the reference sheet.
SHEETS5Returns the number of sheets in a reference.
SIGNReturns the sign of a number.
SINReturns the sine of the given angle
SINGLE6Returns a value using implicit intersection
SINHReturns the hyperbolic sine of a number
SKEWReturns the skewness of a distribution
SKEW.P5Returns 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
SORT6Sorts the values in a range or array by given index and order.
SORTBY6Sorts the values in a range or array based on the values in a corresponding range or array.
SQRTReturns a positive square root
SQRTPIReturns the square root of (number * pi)
STANDARDIZEReturns a normalized value
STDEVEstimates standard deviation based on a sample
STDEV.P4Calculates standard deviation based on the entire population given as arguments.
STDEV.S4Estimates 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
SUMIF2Adds the cells specified by a given criteria
SUMIFS2Adds the cells specified by a given criteria
SUMPRODUCT2Returns 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
SWITCH4Evaluates 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.DIST5Returns the Student’s left-tailed t-distribution.
T.DIST.2T5Returns the two-tailed Student’s t-distribution.
T.DIST.RT5Returns the right-tailed Student’s t-distribution.
T.INV5Returns the left-tailed inverse of the Student’s t-distribution.
T.INV.2T5Returns the two-tailed inverse of the Student’s t-distribution.
T.TEST5Returns 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
TEXT2Formats a number and converts it to text
TEXTJOIN3Combines 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
TREND3Returns values along a linear trend
TRIMRemoves spaces from text
TRIMMEAN1Returns 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
UNICHAR4Returns the Unicode character that is referenced by the given numeric value.
UNICODE4Returns the number (code point) corresponding to the first character of the text.
UNIQUE6Returns a list of unique values from a list or range.
UPPERConverts text to uppercase
VALUEConverts a text argument to a number
VAREstimates variance based on a sample
VAR.P4Calculates variance based on the entire population (ignores logical values and text in the population).
VAR.S4Estimates 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
VLOOKUP2Looks 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
WEIBULL1Returns the Weibull distribution
WEIBULL.DIST4Returns the Weibull distribution.
WORKDAYReturns the serial number of the date before or after a specified number of workdays
WORKDAY.INTL4Returns 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
XLOOKUP7The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds
XNPVReturns the net present value for a schedule of cash flows that is not necessarily periodic
XOR4Returns 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.TEST5Estimates variance based on a sample (ignores logical values and text in the sample).
ZTESTReturns the one-tailed probability-value of a z-test
  1. Limited support. See Formulas with Limited Support for details
  2. 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.
  3. This formula is fully supported in version 6.0 and up.
  4. This formula is fully supported in version 6.1 and up.
  5. This formula is fully supported in version 6.2 and up.
  6. This formula is fully supported in version 6.9 and up.
  7. This formula is fully supported in version 6.25 and up.