Become Awesome... With Functions

Excel Content // Function List


Function Much?

{Calc Anything}


Filter table


All

25

50

75

100


Description Function
Math and trigonometry
Returns the absolute value of a numberABS
Returns the arccosine of a numberACOS
Returns the inverse hyperbolic cosine of a numberACOSH
Returns the arccotangent of a numberACOT
Returns the hyperbolic arccotangent of a numberACOTH
Returns an aggregate in a list or databaseAGGREGATE
Converts a Roman number to Arabic, as a numberARABIC
Returns the arcsine of a numberASIN
Returns the inverse hyperbolic sine of a numberASINH
Returns the arctangent of a numberATAN
Returns the arctangent from x- and y-coordinatesATAN2
Returns the inverse hyperbolic tangent of a numberATANH
Converts a number into a text representation with the given radix (base)BASE
Rounds a number to the nearest integer or to the nearest multiple of significanceCEILING
Rounds a number up, to the nearest integer or to the nearest multiple of significanceCEILING.MATH
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.CEILING.PRECISE
Returns the number of combinations for a given number of objectsCOMBIN
Returns the number of combinations with repetitions for a given number of itemsCOMBINA
Returns the cosine of a numberCOS
Returns the hyperbolic cosine of a numberCOSH
Returns the hyperbolic cosine of a numberCOT
Returns the cotangent of an angleCOTH
Returns the cosecant of an angleCSC
Returns the hyperbolic cosecant of an angleCSCH
Converts a text representation of a number in a given base into a decimal numberDECIMAL
Converts radians to degreesDEGREES
Rounds a number up to the nearest even integerEVEN
Returns e raised to the power of a given numberEXP
Returns the factorial of a numberFACT
Returns the double factorial of a numberFACTDOUBLE
Rounds a number down, to the nearest integer or to the nearest multiple of significanceFLOOR.MATH
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.FLOOR.PRECISE
Returns the greatest common divisorGCD
Rounds a number down to the nearest integerINT
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significanceISO.CEILING
Returns the least common multipleLCM
Returns the natural logarithm of a numberLN
Returns the logarithm of a number to a specified baseLOG
Returns the base-10 logarithm of a numberLOG10
Returns the matrix determinant of an arrayMDETERM
Returns the matrix inverse of an arrayMINVERSE
Returns the matrix product of two arraysMMULT
Returns the remainder from divisionMOD
Returns a number rounded to the desired multipleMROUND
Returns the multinomial of a set of numbersMULTINOMIAL
Returns the unit matrix or the specified dimensionMUNIT
Rounds a number up to the nearest odd integerODD
Returns the value of piPI
Returns the result of a number raised to a powerPOWER
Multiplies its argumentsPRODUCT
Returns the integer portion of a divisionQUOTIENT
Converts degrees to radiansRADIANS
Returns a random number between 0 and 1RAND
Returns a random number between the numbers you specifyRANDBETWEEN
Converts an arabic numeral to roman, as textROMAN
Rounds a number to a specified number of digitsROUND
Rounds a number down, toward zeroROUNDDOWN
Rounds a number up, away from zeroROUNDUP
Returns the secant of an angleSEC
Returns the hyperbolic secant of an angleSECH
Returns the sum of a power series based on the formulaSERIESSUM
Returns the sign of a numberSIGN
Returns the sine of the given angleSIN
Returns the hyperbolic sine of a numberSINH
Returns a positive square rootSQRT
Returns the square root of (number * pi)SQRTPI
Returns a subtotal in a list or databaseSUBTOTAL
Adds its argumentsSUM
Adds the cells specified by a given criteriaSUMIF
Adds the cells in a range that meet multiple criteriaSUMIFS
Returns the sum of the products of corresponding array componentsSUMPRODUCT
Returns the sum of the squares of the argumentsSUMSQ
Returns the sum of the difference of squares of corresponding values in two arraysSUMX2MY2
Returns the sum of the sum of squares of corresponding values in two arraysSUMX2PY2
Returns the sum of squares of differences of corresponding values in two arraysSUMXMY2
Returns the tangent of a numberTAN
Returns the hyperbolic tangent of a numberTANH
Truncates a number to an integerTRUNC
Text
Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) charactersASC
Converts a number to text, using the ? (baht) currency formatBAHTTEXT
Returns the character specified by the code numberCHAR
Removes all nonprintable characters from textCLEAN
Returns a numeric code for the first character in a text stringCODE
Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. Note:?This function isn't available in Excel 2016 for Mac.CONCAT
Joins several text items into one text itemCONCATENATE
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) charactersDBCS
Converts a number to text, using the $ (dollar) currency formatDOLLAR
Checks to see if two text values are identicalEXACT
Finds one text value within another (case-sensitive)FIND, FINDB
Formats a number as text with a fixed number of decimalsFIXED
Changes half-width (single-byte) characters within a string to full-width (double-byte) charactersJIS
Returns the leftmost characters from a text valueLEFT, LEFTB
Returns the number of characters in a text stringLEN, LENB
Converts text to lowercaseLOWER
Returns a specific number of characters from a text string starting at the position you specifyMID, MIDB
Converts text to number in a locale-independent mannerNUMBERVALUE
Extracts the phonetic (furigana) characters from a text stringPHONETIC
Capitalizes the first letter in each word of a text valuePROPER
Replaces characters within textREPLACE, REPLACEB
Repeats text a given number of timesREPT
Returns the rightmost characters from a text valueRIGHT, RIGHTB
Finds one text value within another (not case-sensitive)SEARCH, SEARCHB
Substitutes new text for old text in a text stringSUBSTITUTE
Converts its arguments to textT
Formats a number and converts it to textTEXT
Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. Note:?This function isn't available in Excel 2016 for Mac.TEXTJOIN
Removes spaces from textTRIM
Returns the Unicode character that is references by the given numeric valueUNICHAR
Returns the number (code point) that corresponds to the first character of the textUNICODE
Converts text to uppercaseUPPER
Converts a text argument to a numberVALUE
Logical
Returns TRUE if all of its arguments are TRUEAND
Returns the logical value FALSEFALSE
Specifies a logical test to performIF
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formulaIFERROR
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expressionIFNA
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. Note:?This function isn't available in Excel 2016 for Mac.IFS
Reverses the logic of its argumentNOT
Returns TRUE if any argument is TRUEOR
Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. Note:?This function isn't available in Excel 2016 for Mac.SWITCH
Returns the logical value TRUETRUE
Returns a logical exclusive OR of all argumentsXOR
Date and time
Returns the serial number of a particular dateDATE
Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.DATEDIF
Converts a date in the form of text to a serial numberDATEVALUE
Converts a serial number to a day of the monthDAY
Returns the number of days between two datesDAYS
Calculates the number of days between two dates based on a 360-day yearDAYS360
Returns the serial number of the date that is the indicated number of months before or after the start dateEDATE
Returns the serial number of the last day of the month before or after a specified number of monthsEOMONTH
Converts a serial number to an hourHOUR
Returns the number of the ISO week number of the year for a given dateISOWEEKNUM
Converts a serial number to a minuteMINUTE
Converts a serial number to a monthMONTH
Returns the number of whole workdays between two datesNETWORKDAYS
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend daysNETWORKDAYS.INTL
Returns the serial number of the current date and timeNOW
Converts a serial number to a secondSECOND
Returns the serial number of a particular timeTIME
Converts a time in the form of text to a serial numberTIMEVALUE
Returns the serial number of today's dateTODAY
Converts a serial number to a day of the weekWEEKDAY
Converts a serial number to a number representing where the week falls numerically with a yearWEEKNUM
Returns the serial number of the date before or after a specified number of workdaysWORKDAY
Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend daysWORKDAY.INTL
Converts a serial number to a yearYEAR
Returns the year fraction representing the number of whole days between start_date and end_dateYEARFRAC
Lookup and reference
Returns a reference as text to a single cell in a worksheetADDRESS
Returns the number of areas in a referenceAREAS
Chooses a value from a list of valuesCHOOSE
Returns the column number of a referenceCOLUMN
Returns the number of columns in a referenceCOLUMNS
Returns the formula at the given reference as textFORMULATEXT
Looks in the top row of an array and returns the value of the indicated cellHLOOKUP
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the InternetHYPERLINK
Uses an index to choose a value from a reference or arrayINDEX
Returns a reference indicated by a text valueINDIRECT
Looks up values in a vector or arrayLOOKUP
Looks up values in a reference or arrayMATCH
Returns a reference offset from a given referenceOFFSET
Returns the row number of a referenceROW
Returns the number of rows in a referenceROWS
Retrieves real-time data from a program that supports COM automationRTD
Returns the transpose of an arrayTRANSPOSE
Looks in the first column of an array and moves across the row to return the value of a cellVLOOKUP
Financial
Returns the accrued interest for a security that pays periodic interestACCRINT
Returns the accrued interest for a security that pays interest at maturityACCRINTM
Returns the depreciation for each accounting period by using a depreciation coefficientAMORDEGRC
Returns the depreciation for each accounting periodAMORLINC
Returns the number of days from the beginning of the coupon period to the settlement dateCOUPDAYBS
Returns the number of days in the coupon period that contains the settlement dateCOUPDAYS
Returns the number of days from the settlement date to the next coupon dateCOUPDAYSNC
Returns the next coupon date after the settlement dateCOUPNCD
Returns the number of coupons payable between the settlement date and maturity dateCOUPNUM
Returns the previous coupon date before the settlement dateCOUPPCD
Returns the cumulative interest paid between two periodsCUMIPMT
Returns the cumulative principal paid on a loan between two periodsCUMPRINC
Returns the depreciation of an asset for a specified period by using the fixed-declining balance methodDB
Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specifyDDB
Returns the discount rate for a securityDISC
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal numberDOLLARDE
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fractionDOLLARFR
Returns the annual duration of a security with periodic interest paymentsDURATION
Returns the effective annual interest rateEFFECT
Returns the future value of an investmentFV
Returns the future value of an initial principal after applying a series of compound interest ratesFVSCHEDULE
Returns the interest rate for a fully invested securityINTRATE
Returns the interest payment for an investment for a given periodIPMT
Returns the internal rate of return for a series of cash flowsIRR
Calculates the interest paid during a specific period of an investmentISPMT
Returns the Macauley modified duration for a security with an assumed par value of $100MDURATION
Returns the internal rate of return where positive and negative cash flows are financed at different ratesMIRR
Returns the annual nominal interest rateNOMINAL
Returns the number of periods for an investmentNPER
Returns the net present value of an investment based on a series of periodic cash flows and a discount rateNPV
Returns the price per $100 face value of a security with an odd first periodODDFPRICE
Returns the yield of a security with an odd first periodODDFYIELD
Returns the price per $100 face value of a security with an odd last periodODDLPRICE
Returns the yield of a security with an odd last periodODDLYIELD
Returns the number of periods required by an investment to reach a specified valuePDURATION
Returns the periodic payment for an annuityPMT
Returns the payment on the principal for an investment for a given periodPPMT
Returns the price per $100 face value of a security that pays periodic interestPRICE
Returns the price per $100 face value of a discounted securityPRICEDISC
Returns the price per $100 face value of a security that pays interest at maturityPRICEMAT
Returns the present value of an investmentPV
Returns the interest rate per period of an annuityRATE
Returns the amount received at maturity for a fully invested securityRECEIVED
Returns an equivalent interest rate for the growth of an investmentRRI
Returns the straight-line depreciation of an asset for one periodSLN
Returns the sum-of-years' digits depreciation of an asset for a specified periodSYD
Returns the bond-equivalent yield for a Treasury billTBILLEQ
Returns the price per $100 face value for a Treasury billTBILLPRICE
Returns the yield for a Treasury billTBILLYIELD
Returns the depreciation of an asset for a specified or partial period by using a declining balance methodVDB
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodicXIRR
Returns the net present value for a schedule of cash flows that is not necessarily periodicXNPV
Returns the yield on a security that pays periodic interestYIELD
Returns the annual yield for a discounted security; for example, a Treasury billYIELDDISC
Returns the annual yield of a security that pays interest at maturityYIELDMAT
Information
Returns information about the formatting, location, or contents of a cell Note:? This function is not available in Excel Online.CELL
Returns a number corresponding to an error typeERROR.TYPE
Returns information about the current operating environment Note:? This function is not available in Excel Online.INFO
Returns TRUE if the value is blankISBLANK
Returns TRUE if the value is any error value except #N/AISERR
Returns TRUE if the value is any error valueISERROR
Returns TRUE if the number is evenISEVEN
Returns TRUE if there is a reference to a cell that contains a formulaISFORMULA
Returns TRUE if the value is a logical valueISLOGICAL
Returns TRUE if the value is the #N/A error valueISNA
Returns TRUE if the value is not textISNONTEXT
Returns TRUE if the value is a numberISNUMBER
Returns TRUE if the number is oddISODD
Returns TRUE if the value is a referenceISREF
Returns TRUE if the value is textISTEXT
Returns a value converted to a numberN
Returns the error value #N/ANA
Returns the sheet number of the referenced sheetSHEET
Returns the number of sheets in a referenceSHEETS
Returns a number indicating the data type of a valueTYPE
Statistical
Returns the average of the absolute deviations of data points from their meanAVEDEV
Returns the average of its argumentsAVERAGE
Returns the average of its arguments, including numbers, text, and logical valuesAVERAGEA
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteriaAVERAGEIF
Returns the average (arithmetic mean) of all cells that meet multiple criteria.AVERAGEIFS
Returns the beta cumulative distribution functionBETA.DIST
Returns the inverse of the cumulative distribution function for a specified beta distributionBETA.INV
Returns the individual term binomial distribution probabilityBINOM.DIST
Returns the probability of a trial result using a binomial distributionBINOM.DIST.RANGE
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion valueBINOM.INV
Returns the cumulative beta probability density functionCHISQ.DIST
Returns the one-tailed probability of the chi-squared distributionCHISQ.DIST.RT
Returns the cumulative beta probability density functionCHISQ.INV
Returns the inverse of the one-tailed probability of the chi-squared distributionCHISQ.INV.RT
Returns the test for independenceCHISQ.TEST
Returns the confidence interval for a population meanCONFIDENCE.NORM
Returns the confidence interval for a population mean, using a Student's t distributionCONFIDENCE.T
Returns the correlation coefficient between two data setsCORREL
Counts how many numbers are in the list of argumentsCOUNT
Counts how many values are in the list of argumentsCOUNTA
Counts the number of blank cells within a rangeCOUNTBLANK
Counts the number of cells within a range that meet the given criteriaCOUNTIF
Counts the number of cells within a range that meet multiple criteriaCOUNTIFS
Returns covariance, the average of the products of paired deviationsCOVARIANCE.P
Returns the sample covariance, the average of the products deviations for each data point pair in two data setsCOVARIANCE.S
Returns the sum of squares of deviationsDEVSQ
Returns the exponential distributionEXPON.DIST
Returns the F probability distributionF.DIST
Returns the F probability distributionF.DIST.RT
Returns the inverse of the F probability distributionF.INV
Returns the inverse of the F probability distributionF.INV.RT
Returns the result of an F-testF.TEST
Returns the inverse of the F probability distributionFINV
Returns the Fisher transformationFISHER
Returns the inverse of the Fisher transformationFISHERINV
Returns a value along a linear trend Note:?In Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it's still available for compatibility with earlier versions.FORECAST
Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm Note:?This function isn't available in Excel 2016 for Mac.FORECAST.ETS
Returns a confidence interval for the forecast value at the specified target date Note:?This function isn't available in Excel 2016 for Mac.FORECAST.ETS.CONFINT
Returns the length of the repetitive pattern Excel detects for the specified time series Note:?This function isn't available in Excel 2016 for Mac.FORECAST.ETS.SEASONALITY
Returns a statistical value as a result of time series forecasting Note:?This function isn't available in Excel 2016 for Mac.FORECAST.ETS.STAT
Returns a future value based on existing values Note:?This function isn't available in Excel 2016 for Mac.FORECAST.LINEAR
Returns a frequency distribution as a vertical arrayFREQUENCY
Returns the Gamma function valueGAMMA
Returns the gamma distributionGAMMA.DIST
Returns the inverse of the gamma cumulative distributionGAMMA.INV
Returns the natural logarithm of the gamma function, _(x)GAMMALN
Returns the natural logarithm of the gamma function, _(x)GAMMALN.PRECISE
Returns 0.5 less than the standard normal cumulative distributionGAUSS
Returns the geometric meanGEOMEAN
Returns values along an exponential trendGROWTH
Returns the harmonic meanHARMEAN
Returns the hypergeometric distributionHYPGEOM.DIST
Returns the intercept of the linear regression lineINTERCEPT
Returns the kurtosis of a data setKURT
Returns the k-th largest value in a data setLARGE
Returns the parameters of a linear trendLINEST
Returns the parameters of an exponential trendLOGEST
Returns the cumulative lognormal distributionLOGNORM.DIST
Returns the inverse of the lognormal cumulative distributionLOGNORM.INV
Returns the maximum value in a list of argumentsMAX
Returns the maximum value in a list of arguments, including numbers, text, and logical valuesMAXA
Returns the maximum value among cells specified by a given set of conditions or criteria Note:?This function isn't available in Excel 2016 for Mac.MAXIFS
Returns the median of the given numbersMEDIAN
Returns the minimum value in a list of argumentsMIN
Returns the smallest value in a list of arguments, including numbers, text, and logical valuesMINA
Returns the minimum value among cells specified by a given set of conditions or criteria. Note:?This function isn't available in Excel 2016 for Mac.MINIFS
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of dataMODE.MULT
Returns the most common value in a data setMODE.SNGL
Returns the negative binomial distributionNEGBINOM.DIST
Returns the normal cumulative distributionNORM.DIST
Returns the standard normal cumulative distributionNORM.S.DIST
Returns the inverse of the standard normal cumulative distributionNORM.S.INV
Returns the inverse of the normal cumulative distributionNORMINV
Returns the Pearson product moment correlation coefficientPEARSON
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusivePERCENTILE.EXC
Returns the k-th percentile of values in a rangePERCENTILE.INC
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data setPERCENTRANK.EXC
Returns the percentage rank of a value in a data setPERCENTRANK.INC
Returns the number of permutations for a given number of objectsPERMUT
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objectsPERMUTATIONA
Returns the value of the density function for a standard normal distributionPHI
Returns the Poisson distributionPOISSON.DIST
Returns the probability that values in a range are between two limitsPROB
Returns the quartile of the data set, based on percentile values from 0..1, exclusiveQUARTILE.EXC
Returns the quartile of a data setQUARTILE.INC
Returns the rank of a number in a list of numbersRANK.AVG
Returns the rank of a number in a list of numbersRANK.EQ
Returns the square of the Pearson product moment correlation coefficientRSQ
Returns the skewness of a distributionSKEW
Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its meanSKEW.P
Returns the slope of the linear regression lineSLOPE
Returns the k-th smallest value in a data setSMALL
Returns a normalized valueSTANDARDIZE
Calculates standard deviation based on the entire populationSTDEV.P
Estimates standard deviation based on a sampleSTDEV.S
Estimates standard deviation based on a sample, including numbers, text, and logical valuesSTDEVA
Calculates standard deviation based on the entire population, including numbers, text, and logical valuesSTDEVPA
Returns the standard error of the predicted y-value for each x in the regressionSTEYX
Returns the Percentage Points (probability) for the Student t-distributionT.DIST
Returns the Percentage Points (probability) for the Student t-distributionT.DIST.2T
Returns the Student's t-distributionT.DIST.RT
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedomT.INV
Returns the inverse of the Student's t-distributionT.INV.2T
Returns the probability associated with a Student's t-testT.TEST
Returns values along a linear trendTREND
Returns the mean of the interior of a data setTRIMMEAN
Calculates variance based on the entire populationVAR.P
Estimates variance based on a sampleVAR.S
Estimates variance based on a sample, including numbers, text, and logical valuesVARA
Calculates variance based on the entire population, including numbers, text, and logical valuesVARPA
Returns the Weibull distributionWEIBULL.DIST
Returns the one-tailed probability-value of a z-testZ.TEST
Add-in and Automation
Calls a procedure in a dynamic link library or code resourceCALL
Converts 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).EUROCONVERT
Returns data stored in a PivotTable reportGETPIVOTDATA
Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registeredREGISTER.ID
Connects with an external data source and runs a query from a worksheet, then returns the result as an array without the need for macro programmingSQL.REQUEST
Compatibility
Returns the beta cumulative distribution function Note:?In Excel 2007, this is a Statistical function.BETADIST
Returns the inverse of the cumulative distribution function for a specified beta distribution Note:?In Excel 2007, this is a Statistical function.BETAINV
Returns the individual term binomial distribution probability Note:?In Excel 2007, this is a Statistical function.BINOMDIST
Returns the one-tailed probability of the chi-squared distribution Note:?In Excel 2007, this is a Statistical function.CHIDIST
Returns the inverse of the one-tailed probability of the chi-squared distribution Note:?In Excel 2007, this is a Statistical function.CHIINV
Returns the test for independence Note:?In Excel 2007, this is a Statistical function.CHITEST
Returns the confidence interval for a population mean Note:?In Excel 2007, this is a Statistical function.CONFIDENCE
Returns covariance, the average of the products of paired deviations Note:?In Excel 2007, this is a Statistical function.COVAR
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value Note:?In Excel 2007, this is a Statistical function.CRITBINOM
Returns the exponential distribution Note:?In Excel 2007, this is a Statistical function.EXPONDIST
Returns the F probability distribution Note:?In Excel 2007, this is a Statistical function.FDIST
Rounds a number down, toward zero Note:?In Excel 2007 and Excel 2010, this is a Math and trigonometry function.FLOOR
Returns the result of an F-test Note:?In Excel 2007, this is a Statistical function.FTEST
Returns the gamma distribution Note:?In Excel 2007, this is a Statistical function.GAMMADIST
Returns the inverse of the gamma cumulative distribution Note:?In Excel 2007, this is a Statistical function.GAMMAINV
Returns the hypergeometric distribution Note:?In Excel 2007, this is a Statistical function.HYPGEOMDIST
Returns the inverse of the lognormal cumulative distributionLOGINV
Returns the cumulative lognormal distributionLOGNORMDIST
Returns the most common value in a data set Note:?In Excel 2007, this is a Statistical function.MODE
Returns the negative binomial distribution Note:?In Excel 2007, this is a Statistical function.NEGBINOMDIST
Returns the inverse of the normal cumulative distribution Note:?In Excel 2007, this is a Statistical function.NORM.INV
Returns the normal cumulative distribution Note:?In Excel 2007, this is a Statistical function.NORMDIST
Returns the standard normal cumulative distribution Note:?In Excel 2007, this is a Statistical function.NORMSDIST
Returns the inverse of the standard normal cumulative distribution Note:?In Excel 2007, this is a Statistical function.NORMSINV
Returns the k-th percentile of values in a range Note:?In Excel 2007, this is a Statistical function.PERCENTILE
Returns the percentage rank of a value in a data set Note:?In Excel 2007, this is a Statistical function.PERCENTRANK
Returns the Poisson distribution Note:?In Excel 2007, this is a Statistical function.POISSON
Returns the quartile of a data set Note:?In Excel 2007, this is a Statistical function.QUARTILE
Returns the rank of a number in a list of numbers Note:?In Excel 2007, this is a Statistical function.RANK
Estimates standard deviation based on a sampleSTDEV
Calculates standard deviation based on the entire population Note:?In Excel 2007, this is a Statistical function.STDEVP
Returns the Student's t-distributionTDIST
Returns the inverse of the Student's t-distributionTINV
Returns the probability associated with a Student's t-test Note:?In Excel 2007, this is a Statistical function.TTEST
Estimates variance based on a sample Note:?In Excel 2007, this is a Statistical function.VAR
Calculates variance based on the entire population Note:?In Excel 2007, this is a Statistical function.VARP
Calculates variance based on the entire population, including numbers, text, and logical values Note:?In Excel 2007, this is a Statistical function.WEIBULL
Returns the one-tailed probability-value of a z-test Note:?In Excel 2007, this is a Statistical function.ZTEST
Engineering
Returns the modified Bessel function In(x)BESSELI
Returns the Bessel function Jn(x)BESSELJ
Returns the modified Bessel function Kn(x)BESSELK
Returns the Bessel function Yn(x)BESSELY
Converts a binary number to decimalBIN2DEC
Converts a binary number to hexadecimalBIN2HEX
Converts a binary number to octalBIN2OCT
Returns a 'Bitwise And' of two numbersBITAND
Returns a value number shifted left by shift_amount bitsBITLSHIFT
Returns a bitwise OR of 2 numbersBITOR
Returns a value number shifted right by shift_amount bitsBITRSHIFT
Returns a bitwise 'Exclusive Or' of two numbersBITXOR
Converts real and imaginary coefficients into a complex numberCOMPLEX
Converts a number from one measurement system to anotherCONVERT
Converts a decimal number to binaryDEC2BIN
Converts a decimal number to hexadecimalDEC2HEX
Converts a decimal number to octalDEC2OCT
Tests whether two values are equalDELTA
Returns the error functionERF
Returns the error functionERF.PRECISE
Returns the complementary error functionERFC
Returns the complementary ERF function integrated between x and infinityERFC.PRECISE
Tests whether a number is greater than a threshold valueGESTEP
Converts a hexadecimal number to binaryHEX2BIN
Converts a hexadecimal number to decimalHEX2DEC
Converts a hexadecimal number to octalHEX2OCT
Returns the absolute value (modulus) of a complex numberIMABS
Returns the imaginary coefficient of a complex numberIMAGINARY
Returns the argument theta, an angle expressed in radiansIMARGUMENT
Returns the complex conjugate of a complex numberIMCONJUGATE
Returns the cosine of a complex numberIMCOS
Returns the hyperbolic cosine of a complex numberIMCOSH
Returns the cotangent of a complex numberIMCOT
Returns the cosecant of a complex numberIMCSC
Returns the hyperbolic cosecant of a complex numberIMCSCH
Returns the quotient of two complex numbersIMDIV
Returns the exponential of a complex numberIMEXP
Returns the natural logarithm of a complex numberIMLN
Returns the base-10 logarithm of a complex numberIMLOG10
Returns the base-2 logarithm of a complex numberIMLOG2
Returns a complex number raised to an integer powerIMPOWER
Returns the product of complex numbersIMPRODUCT
Returns the real coefficient of a complex numberIMREAL
Returns the secant of a complex numberIMSEC
Returns the hyperbolic secant of a complex numberIMSECH
Returns the sine of a complex numberIMSIN
Returns the hyperbolic sine of a complex numberIMSINH
Returns the square root of a complex numberIMSQRT
Returns the difference between two complex numbersIMSUB
Returns the sum of complex numbersIMSUM
Returns the tangent of a complex numberIMTAN
Converts an octal number to binaryOCT2BIN
Converts an octal number to decimalOCT2DEC
Converts an octal number to hexadecimalOCT2HEX
Database
Returns the average of selected database entriesDAVERAGE
Counts the cells that contain numbers in a databaseDCOUNT
Counts nonblank cells in a databaseDCOUNTA
Extracts from a database a single record that matches the specified criteriaDGET
Returns the maximum value from selected database entriesDMAX
Returns the minimum value from selected database entriesDMIN
Multiplies the values in a particular field of records that match the criteria in a databaseDPRODUCT
Estimates the standard deviation based on a sample of selected database entriesDSTDEV
Calculates the standard deviation based on the entire population of selected database entriesDSTDEVP
Adds the numbers in the field column of records in the database that match the criteriaDSUM
Estimates variance based on a sample from selected database entriesDVAR
Calculates variance based on the entire population of selected database entriesDVARP
Cube
Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance.CUBEKPIMEMBER
Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.CUBEMEMBER
Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.CUBEMEMBERPROPERTY
Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students.CUBERANKEDMEMBER
Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel.CUBESET
Returns the number of items in a set.CUBESETCOUNT
Returns an aggregated value from a cube.CUBEVALUE
Web
Returns a URL-encoded string Note:? This function is not available in Excel Online.ENCODEURL
Returns specific data from the XML content by using the specified XPath Note:? This function is not available in Excel Online.FILTERXML
Returns data from a web service. Note:? This function is not available in Excel Online.WEBSERVICE