All Excel Worksheet Functions

The following table listed all Excel worksheet functions

TypeFunction NameDescriptionFirst AvailableDetail
Math and trigonometryABS Returns the absolute value of a number
FinancialACCRINT Returns the accrued interest for a security that pays periodic interest
FinancialACCRINTM Returns the accrued interest for a security that pays interest at maturity
Math and trigonometryACOS Returns the arccosine of a number
Math and trigonometryACOSH Returns the inverse hyperbolic cosine of a number
Math and trigonometryACOTReturns the arccotangent of a number2013
Math and trigonometryACOTHReturns the hyperbolic arccotangent of a number2013
Math and trigonometryAGGREGATE Returns an aggregate in a list or database
Lookup and referenceADDRESS Returns a reference as text to a single cell in a worksheet
FinancialAMORDEGRC Returns the depreciation for each accounting period by using a depreciation coefficient
FinancialAMORLINC Returns the depreciation for each accounting period
LogicalAND Returns TRUE if all of its arguments are TRUE
Math and trigonometryARABICConverts a Roman number to Arabic, as a number2013
Lookup and referenceAREAS Returns the number of areas in a reference
TextASC Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
Math and trigonometryASIN Returns the arcsine of a number
Math and trigonometryASINH Returns the inverse hyperbolic sine of a number
Math and trigonometryATAN Returns the arctangent of a number
Math and trigonometryATAN2 Returns the arctangent from x- and y-coordinates
Math and trigonometryATANH Returns the inverse hyperbolic tangent of a number
StatisticalAVEDEV Returns the average of the absolute deviations of data points from their mean
StatisticalAVERAGE Returns the average of its arguments
StatisticalAVERAGEA Returns the average of its arguments, including numbers, text, and logical values
StatisticalAVERAGEIF Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
StatisticalAVERAGEIFS Returns the average (arithmetic mean) of all cells that meet multiple criteria.
TextBAHTTEXT Converts a number to text, using the ß (baht) currency format
Math and trigonometryBASE Converts a number into a text representation with the given radix (base)
EngineeringBESSELI Returns the modified Bessel function In(x)
EngineeringBESSELJ Returns the Bessel function Jn(x)
EngineeringBESSELK Returns the modified Bessel function Kn(x)
EngineeringBESSELY Returns the Bessel function Yn(x)
CompatibilityBETADIST Returns the beta cumulative distribution function

In Excel 2007, this is a Statistical function.
StatisticalBETA.DIST Returns the beta cumulative distribution function2010
CompatibilityBETAINV Returns the inverse of the cumulative distribution function for a specified beta distribution

In Excel 2007, this is a Statistical function.
StatisticalBETA.INV Returns the inverse of the cumulative distribution function for a specified beta distribution2010
EngineeringBIN2DEC Converts a binary number to decimal
EngineeringBIN2HEX Converts a binary number to hexadecimal
EngineeringBIN2OCT Converts a binary number to octal
CompatibilityBINOMDIST Returns the individual term binomial distribution probability

In Excel 2007, this is a Statistical function.
StatisticalBINOM.DIST Returns the individual term binomial distribution probability2010
StatisticalBINOM.DIST.RANGE Returns the probability of a trial result using a binomial distribution2013
StatisticalBINOM.INV Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value2010
EngineeringBITANDReturns a 'Bitwise And' of two numbers2013
EngineeringBITLSHIFTReturns a value number shifted left by shift_amount bits2013
EngineeringBITORReturns a bitwise OR of 2 numbers2013
EngineeringBITRSHIFTReturns a value number shifted right by shift_amount bits2013
EngineeringBITXORReturns a bitwise 'Exclusive Or' of two numbers2013
Add-in and AutomationCALL Calls a procedure in a dynamic link library or code resource
Math and trigonometryCEILING Rounds a number to the nearest integer or to the nearest multiple of significance
Math and trigonometryCEILING.MATH Rounds a number up, to the nearest integer or to the nearest multiple of significance2013
Math and trigonometryCEILING.PRECISE 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.
InformationCELL Returns information about the formatting, location, or contents of a cell

This function is not available in Excel Online.
TextCHAR Returns the character specified by the code number
CompatibilityCHIDIST Returns the one-tailed probability of the chi-squared distribution

Note: In Excel 2007, this is a Statistical function.
CompatibilityCHIINV Returns the inverse of the one-tailed probability of the chi-squared distribution

Note: In Excel 2007, this is a Statistical function.
CompatibilityCHITEST Returns the test for independence

Note: In Excel 2007, this is a Statistical function.
StatisticalCHISQ.DIST Returns the cumulative beta probability density function2010
StatisticalCHISQ.DIST.RT Returns the one-tailed probability of the chi-squared distribution2010
StatisticalCHISQ.INV Returns the cumulative beta probability density function2010
StatisticalCHISQ.INV.RT Returns the inverse of the one-tailed probability of the chi-squared distribution2010
StatisticalCHISQ.TEST Returns the test for independence2010
Lookup and referenceCHOOSE Chooses a value from a list of values
TextCLEAN Removes all nonprintable characters from text
TextCODE Returns a numeric code for the first character in a text string
Lookup and referenceCOLUMN Returns the column number of a reference
Lookup and referenceCOLUMNS Returns the number of columns in a reference
Math and trigonometryCOMBIN Returns the number of combinations for a given number of objects
Math and trigonometryCOMBINA2013
EngineeringCOMPLEX Converts real and imaginary coefficients into a complex number
TextCONCATCombines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.2016
TextCONCATENATE Joins several text items into one text item
CompatibilityCONFIDENCE Returns the confidence interval for a population mean

In Excel 2007, this is a Statistical function.
StatisticalCONFIDENCE.NORM Returns the confidence interval for a population mean2010
StatisticalCONFIDENCE.T Returns the confidence interval for a population mean, using a Student's t distribution2010
EngineeringCONVERT Converts a number from one measurement system to another
StatisticalCORREL Returns the correlation coefficient between two data sets
Math and trigonometryCOS Returns the cosine of a number
Math and trigonometryCOSH Returns the hyperbolic cosine of a number
Math and trigonometryCOTReturns the hyperbolic cosine of a number2013
Math and trigonometryCOTHReturns the cotangent of an angle2013
StatisticalCOUNT Counts how many numbers are in the list of arguments
StatisticalCOUNTA Counts how many values are in the list of arguments
StatisticalCOUNTBLANK Counts the number of blank cells within a range
StatisticalCOUNTIF Counts the number of cells within a range that meet the given criteria
StatisticalCOUNTIFS Counts the number of cells within a range that meet multiple criteria
FinancialCOUPDAYBS Returns the number of days from the beginning of the coupon period to the settlement date
FinancialCOUPDAYS Returns the number of days in the coupon period that contains the settlement date
FinancialCOUPDAYSNC Returns the number of days from the settlement date to the next coupon date
FinancialCOUPNCD Returns the next coupon date after the settlement date
FinancialCOUPNUM Returns the number of coupons payable between the settlement date and maturity date
FinancialCOUPPCD Returns the previous coupon date before the settlement date
CompatibilityCOVAR Returns covariance, the average of the products of paired deviations

In Excel 2007, this is a Statistical function.
StatisticalCOVARIANCE.P Returns covariance, the average of the products of paired deviations2010
StatisticalCOVARIANCE.S Returns the sample covariance, the average of the products deviations for each data point pair in two data sets2010
CompatibilityCRITBINOM Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value

In Excel 2007, this is a Statistical function.
Math and trigonometryCSCReturns the cosecant of an angle2013
Math and trigonometryCSCHReturns the hyperbolic cosecant of an angle2013
CubeCUBEKPIMEMBER 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.
CubeCUBEMEMBER Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.
CubeCUBEMEMBERPROPERTY 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.
CubeCUBERANKEDMEMBER 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.
CubeCUBESET 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.
CubeCUBESETCOUNT Returns the number of items in a set.
CubeCUBEVALUE Returns an aggregated value from a cube.
FinancialCUMIPMT Returns the cumulative interest paid between two periods
FinancialCUMPRINC Returns the cumulative principal paid on a loan between two periods
Date and timeDATE Returns the serial number of a particular date
Date and timeDATEDIFCalculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.
Date and timeDATEVALUE Converts a date in the form of text to a serial number
DatabaseDAVERAGE Returns the average of selected database entries
Date and timeDAY Converts a serial number to a day of the month
Date and timeDAYSReturns the number of days between two dates2013
Date and timeDAYS360 Calculates the number of days between two dates based on a 360-day year
FinancialDB Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
TextDBCS Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters2013
DatabaseDCOUNT Counts the cells that contain numbers in a database
DatabaseDCOUNTA Counts nonblank cells in a database
FinancialDDB Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
EngineeringDEC2BIN Converts a decimal number to binary
EngineeringDEC2HEX Converts a decimal number to hexadecimal
EngineeringDEC2OCT Converts a decimal number to octal
Math and trigonometryDECIMALConverts a text representation of a number in a given base into a decimal number2013
Math and trigonometryDEGREES Converts radians to degrees
EngineeringDELTA Tests whether two values are equal
StatisticalDEVSQ Returns the sum of squares of deviations
DatabaseDGET Extracts from a database a single record that matches the specified criteria
FinancialDISC Returns the discount rate for a security
DatabaseDMAX Returns the maximum value from selected database entries
DatabaseDMIN Returns the minimum value from selected database entries
TextDOLLAR Converts a number to text, using the $ (dollar) currency format
FinancialDOLLARDE Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
FinancialDOLLARFR Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
DatabaseDPRODUCT Multiplies the values in a particular field of records that match the criteria in a database
DatabaseDSTDEV Estimates the standard deviation based on a sample of selected database entries
DatabaseDSTDEVP Calculates the standard deviation based on the entire population of selected database entries
DatabaseDSUM Adds the numbers in the field column of records in the database that match the criteria
FinancialDURATION Returns the annual duration of a security with periodic interest payments
DatabaseDVAR Estimates variance based on a sample from selected database entries
DatabaseDVARP Calculates variance based on the entire population of selected database entries
Date and timeEDATE Returns the serial number of the date that is the indicated number of months before or after the start date
FinancialEFFECT Returns the effective annual interest rate
WebENCODEURLReturns a URL-encoded string

This function is not available in Excel Online.
2013
Date and timeEOMONTH Returns the serial number of the last day of the month before or after a specified number of months
EngineeringERF Returns the error function
EngineeringERF.PRECISE Returns the error function2010
EngineeringERFC Returns the complementary error function
EngineeringERFC.PRECISE Returns the complementary ERF function integrated between x and infinity2010
InformationERROR.TYPE Returns a number corresponding to an error type
Add-in and AutomationEUROCONVERT 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).
Math and trigonometryEVEN Rounds a number up to the nearest even integer
TextEXACT Checks to see if two text values are identical
Math and trigonometryEXP Returns e raised to the power of a given number
StatisticalEXPON.DIST Returns the exponential distribution2010
CompatibilityEXPONDIST Returns the exponential distribution

In Excel 2007, this is a Statistical function.
Math and trigonometryFACT Returns the factorial of a number
Math and trigonometryFACTDOUBLE Returns the double factorial of a number
LogicalFALSE Returns the logical value FALSE
StatisticalF.DIST Returns the F probability distribution2010
CompatibilityFDIST Returns the F probability distribution

In Excel 2007, this is a Statistical function.
StatisticalF.DIST.RT Returns the F probability distribution2010
WebFILTERXMLReturns specific data from the XML content by using the specified Xpath

This function is not available in Excel Online.
2013
TextFIND, FINDB s Finds one text value within another (case-sensitive)
StatisticalF.INV Returns the inverse of the F probability distribution2010
StatisticalF.INV.RT Returns the inverse of the F probability distribution2010
StatisticalFINV Returns the inverse of the F probability distribution
StatisticalFISHER Returns the Fisher transformation
StatisticalFISHERINV Returns the inverse of the Fisher transformation
TextFIXED Formats a number as text with a fixed number of decimals
CompatibilityFLOOR Rounds a number down, toward zero

In Excel 2007 and Excel 2010, this is a Math and trigonometry function.
Math and trigonometryFLOOR.MATHRounds a number down, to the nearest integer or to the nearest multiple of significance2013
Math and trigonometryFLOOR.PRECISE 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.
StatisticalFORECAST Returns a value along a linear trend

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.
StatisticalFORECAST.ETSReturns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm2016
StatisticalFORECAST.ETS.CONFINTReturns a confidence interval for the forecast value at the specified target date2016
StatisticalFORECAST.ETS.SEASONALITYReturns the length of the repetitive pattern Excel detects for the specified time series2016
StatisticalFORECAST.ETS.STATReturns a statistical value as a result of time series forecasting2016
StatisticalFORECAST.LINEARReturns a future value based on existing values2016
Lookup and referenceFORMULATEXTReturns the formula at the given reference as text2013
StatisticalFREQUENCY Returns a frequency distribution as a vertical array
StatisticalF.TEST Returns the result of an F-test2010
CompatibilityFTEST Returns the result of an F-test

In Excel 2007, this is a Statistical function.
FinancialFV Returns the future value of an investment
FinancialFVSCHEDULE Returns the future value of an initial principal after applying a series of compound interest rates
StatisticalGAMMAReturns the Gamma function value2013
StatisticalGAMMA.DIST Returns the gamma distribution2010
CompatibilityGAMMADIST Returns the gamma distribution

In Excel 2007, this is a Statistical function.
StatisticalGAMMA.INV Returns the inverse of the gamma cumulative distribution2010
CompatibilityGAMMAINV Returns the inverse of the gamma cumulative distribution

In Excel 2007, this is a Statistical function.
StatisticalGAMMALN Returns the natural logarithm of the gamma function, Γ(x)
StatisticalGAMMALN.PRECISE Returns the natural logarithm of the gamma function, Γ(x)2010
StatisticalGAUSS Returns 0.5 less than the standard normal cumulative distribution2013
Math and trigonometryGCD Returns the greatest common divisor
StatisticalGEOMEAN Returns the geometric mean
EngineeringGESTEP Tests whether a number is greater than a threshold value
Lookup and referenceGETPIVOTDATA Returns data stored in a PivotTable report
StatisticalGROWTH Returns values along an exponential trend
StatisticalHARMEAN Returns the harmonic mean
EngineeringHEX2BIN Converts a hexadecimal number to binary
EngineeringHEX2DEC Converts a hexadecimal number to decimal
EngineeringHEX2OCT Converts a hexadecimal number to octal
Lookup and referenceHLOOKUP Looks in the top row of an array and returns the value of the indicated cell
Date and timeHOUR Converts a serial number to an hour
Lookup and referenceHYPERLINK Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
StatisticalHYPGEOM.DIST Returns the hypergeometric distribution
CompatibilityHYPGEOMDIST Returns the hypergeometric distribution

In Excel 2007, this is a Statistical function.
LogicalIF Specifies a logical test to perform
LogicalIFERROR Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
LogicalIFNAReturns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression2013
LogicalIFSChecks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

This function isn't available in Excel 2016 for Mac.
2016
EngineeringIMABS Returns the absolute value (modulus) of a complex number
EngineeringIMAGINARY Returns the imaginary coefficient of a complex number
EngineeringIMARGUMENT Returns the argument theta, an angle expressed in radians
EngineeringIMCONJUGATE Returns the complex conjugate of a complex number
EngineeringIMCOS Returns the cosine of a complex number
EngineeringIMCOSH Returns the hyperbolic cosine of a complex number2013
EngineeringIMCOTReturns the cotangent of a complex number2013
EngineeringIMCSCReturns the cosecant of a complex number2013
EngineeringIMCSCHReturns the hyperbolic cosecant of a complex number2013
EngineeringIMDIV Returns the quotient of two complex numbers
EngineeringIMEXP Returns the exponential of a complex number
EngineeringIMLN Returns the natural logarithm of a complex number
EngineeringIMLOG10 Returns the base-10 logarithm of a complex number
EngineeringIMLOG2 Returns the base-2 logarithm of a complex number
EngineeringIMPOWER Returns a complex number raised to an integer power
EngineeringIMPRODUCT Returns the product of complex numbers
EngineeringIMREAL Returns the real coefficient of a complex number
EngineeringIMSECReturns the secant of a complex number2013
EngineeringIMSECHReturns the hyperbolic secant of a complex number2013
EngineeringIMSIN Returns the sine of a complex number
EngineeringIMSINHReturns the hyperbolic sine of a complex number2013
EngineeringIMSQRT Returns the square root of a complex number
EngineeringIMSUB Returns the difference between two complex numbers
EngineeringIMSUM Returns the sum of complex numbers
EngineeringIMTANReturns the tangent of a complex number2013
Lookup and referenceINDEX Uses an index to choose a value from a reference or array
Lookup and referenceINDIRECT Returns a reference indicated by a text value
InformationINFO Returns information about the current operating environment

This function is not available in Excel Online.
Math and trigonometryINT Rounds a number down to the nearest integer
StatisticalINTERCEPT Returns the intercept of the linear regression line
FinancialINTRATE Returns the interest rate for a fully invested security
FinancialIPMT Returns the interest payment for an investment for a given period
FinancialIRR Returns the internal rate of return for a series of cash flows
InformationISBLANK Returns TRUE if the value is blank
InformationISERR Returns TRUE if the value is any error value except #N/A
InformationISERROR Returns TRUE if the value is any error value
InformationISEVEN Returns TRUE if the number is even
InformationISFORMULAReturns TRUE if there is a reference to a cell that contains a formula2013
InformationISLOGICAL Returns TRUE if the value is a logical value
InformationISNA Returns TRUE if the value is the #N/A error value
InformationISNONTEXT Returns TRUE if the value is not text
InformationISNUMBER Returns TRUE if the value is a number
InformationISODD Returns TRUE if the number is odd
InformationISREF Returns TRUE if the value is a reference
InformationISTEXT Returns TRUE if the value is text
Math and trigonometryISO.CEILING Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance2013
Date and timeISOWEEKNUMReturns the number of the ISO week number of the year for a given date2013
FinancialISPMT Calculates the interest paid during a specific period of an investment
TextJISChanges half-width (single-byte) characters within a string to full-width (double-byte) characters
StatisticalKURT Returns the kurtosis of a data set
StatisticalLARGE Returns the k-th largest value in a data set
Math and trigonometryLCM Returns the least common multiple
TextLEFT, LEFTB s Returns the leftmost characters from a text value
TextLEN, LENB s Returns the number of characters in a text string
StatisticalLINEST Returns the parameters of a linear trend
Math and trigonometryLN Returns the natural logarithm of a number
Math and trigonometryLOG Returns the logarithm of a number to a specified base
Math and trigonometryLOG10 Returns the base-10 logarithm of a number
StatisticalLOGEST Returns the parameters of an exponential trend
CompatibilityLOGINV Returns the inverse of the lognormal cumulative distribution
StatisticalLOGNORM.DIST Returns the cumulative lognormal distribution2010
CompatibilityLOGNORMDIST Returns the cumulative lognormal distribution
StatisticalLOGNORM.INV Returns the inverse of the lognormal cumulative distribution2010
Lookup and referenceLOOKUP Looks up values in a vector or array
TextLOWER Converts text to lowercase
Lookup and referenceMATCH Looks up values in a reference or array
StatisticalMAX Returns the maximum value in a list of arguments
StatisticalMAXA Returns the maximum value in a list of arguments, including numbers, text, and logical values
StatisticalMAXIFSReturns the maximum value among cells specified by a given set of conditions or criteria2016
Math and trigonometryMDETERM Returns the matrix determinant of an array
FinancialMDURATION Returns the Macauley modified duration for a security with an assumed par value of $100
StatisticalMEDIAN Returns the median of the given numbers
TextMID, MIDB s Returns a specific number of characters from a text string starting at the position you specify
StatisticalMIN Returns the minimum value in a list of arguments
StatisticalMINIFSReturns the minimum value among cells specified by a given set of conditions or criteria.2016
StatisticalMINA Returns the smallest value in a list of arguments, including numbers, text, and logical values
Date and timeMINUTE Converts a serial number to a minute
Math and trigonometryMINVERSE Returns the matrix inverse of an array
FinancialMIRR Returns the internal rate of return where positive and negative cash flows are financed at different rates
Math and trigonometryMMULT Returns the matrix product of two arrays
Math and trigonometryMOD Returns the remainder from division
CompatibilityMODE Returns the most common value in a data set

In Excel 2007, this is a Statistical function.
StatisticalMODE.MULT Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data2010
StatisticalMODE.SNGL Returns the most common value in a data set2010
Date and timeMONTH Converts a serial number to a month
Math and trigonometryMROUND Returns a number rounded to the desired multiple
Math and trigonometryMULTINOMIAL Returns the multinomial of a set of numbers
Math and trigonometryMUNITReturns the unit matrix or the specified dimension2013
InformationN Returns a value converted to a number
InformationNA Returns the error value #N/A
StatisticalNEGBINOM.DIST Returns the negative binomial distribution2010
CompatibilityNEGBINOMDIST Returns the negative binomial distribution

In Excel 2007, this is a Statistical function.
Date and timeNETWORKDAYS Returns the number of whole workdays between two dates
Date and timeNETWORKDAYS.INTL Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days2010
FinancialNOMINAL Returns the annual nominal interest rate
StatisticalNORM.DIST Returns the normal cumulative distribution2010
CompatibilityNORMDIST Returns the normal cumulative distribution

In Excel 2007, this is a Statistical function.
StatisticalNORMINV Returns the inverse of the normal cumulative distribution
CompatibilityNORM.INV Returns the inverse of the normal cumulative distribution

Note: In Excel 2007, this is a Statistical function.
2010
StatisticalNORM.S.DIST Returns the standard normal cumulative distribution2010
CompatibilityNORMSDIST Returns the standard normal cumulative distribution

In Excel 2007, this is a Statistical function.
StatisticalNORM.S.INV Returns the inverse of the standard normal cumulative distribution2010
CompatibilityNORMSINV Returns the inverse of the standard normal cumulative distribution

In Excel 2007, this is a Statistical function.
LogicalNOT Reverses the logic of its argument
Date and timeNOW Returns the serial number of the current date and time
FinancialNPER Returns the number of periods for an investment
FinancialNPV Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
TextNUMBERVALUE Converts text to number in a locale-independent manner2013
EngineeringOCT2BIN Converts an octal number to binary
EngineeringOCT2DEC Converts an octal number to decimal
EngineeringOCT2HEX Converts an octal number to hexadecimal
Math and trigonometryODD Rounds a number up to the nearest odd integer
FinancialODDFPRICE Returns the price per $100 face value of a security with an odd first period
FinancialODDFYIELD Returns the yield of a security with an odd first period
FinancialODDLPRICE Returns the price per $100 face value of a security with an odd last period
FinancialODDLYIELD Returns the yield of a security with an odd last period
Lookup and referenceOFFSET Returns a reference offset from a given reference
LogicalOR Returns TRUE if any argument is TRUE
FinancialPDURATIONReturns the number of periods required by an investment to reach a specified value2013
StatisticalPEARSON Returns the Pearson product moment correlation coefficient
StatisticalPERCENTILE.EXC Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive2010
StatisticalPERCENTILE.INC Returns the k-th percentile of values in a range2010
CompatibilityPERCENTILE Returns the k-th percentile of values in a range

In Excel 2007, this is a Statistical function.
StatisticalPERCENTRANK.EXC Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set2010
StatisticalPERCENTRANK.INC Returns the percentage rank of a value in a data set2010
CompatibilityPERCENTRANK Returns the percentage rank of a value in a data set

In Excel 2007, this is a Statistical function.
StatisticalPERMUT Returns the number of permutations for a given number of objects
StatisticalPERMUTATIONAReturns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects2013
StatisticalPHIReturns the value of the density function for a standard normal distribution2013
TextPHONETIC Extracts the phonetic (furigana) characters from a text string
Math and trigonometryPI Returns the value of pi
FinancialPMT Returns the periodic payment for an annuity
StatisticalPOISSON.DIST Returns the Poisson distribution2010
CompatibilityPOISSON Returns the Poisson distribution

In Excel 2007, this is a Statistical function.
Math and trigonometryPOWER Returns the result of a number raised to a power
FinancialPPMT Returns the payment on the principal for an investment for a given period
FinancialPRICE Returns the price per $100 face value of a security that pays periodic interest
FinancialPRICEDISC Returns the price per $100 face value of a discounted security
FinancialPRICEMAT Returns the price per $100 face value of a security that pays interest at maturity
StatisticalPROB Returns the probability that values in a range are between two limits
Math and trigonometryPRODUCT Multiplies its arguments
TextPROPER Capitalizes the first letter in each word of a text value
FinancialPV Returns the present value of an investment
CompatibilityQUARTILE Returns the quartile of a data set

In Excel 2007, this is a Statistical function.
StatisticalQUARTILE.EXC Returns the quartile of the data set, based on percentile values from 0..1, exclusive2010
StatisticalQUARTILE.INC Returns the quartile of a data set2010
Math and trigonometryQUOTIENT Returns the integer portion of a division
Math and trigonometryRADIANS Converts degrees to radians
Math and trigonometryRAND Returns a random number between 0 and 1
Math and trigonometryRANDBETWEEN Returns a random number between the numbers you specify
StatisticalRANK.AVG Returns the rank of a number in a list of numbers2010
StatisticalRANK.EQ Returns the rank of a number in a list of numbers2010
CompatibilityRANK Returns the rank of a number in a list of numbers

In Excel 2007, this is a Statistical function.
FinancialRATE Returns the interest rate per period of an annuity
FinancialRECEIVED Returns the amount received at maturity for a fully invested security
Add-in and AutomationREGISTER.ID Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered
TextREPLACE, REPLACEB s Replaces characters within text
TextREPT Repeats text a given number of times
TextRIGHT, RIGHTB s Returns the rightmost characters from a text value
Math and trigonometryROMAN Converts an arabic numeral to roman, as text
Math and trigonometryROUND Rounds a number to a specified number of digits
Math and trigonometryROUNDDOWN Rounds a number down, toward zero
Math and trigonometryROUNDUP Rounds a number up, away from zero
Lookup and referenceROW Returns the row number of a reference
Lookup and referenceROWS Returns the number of rows in a reference
FinancialRRIReturns an equivalent interest rate for the growth of an investment2013
StatisticalRSQ Returns the square of the Pearson product moment correlation coefficient
Lookup and referenceRTD Retrieves real-time data from a program that supports COM automation
TextSEARCH, SEARCHB s Finds one text value within another (not case-sensitive)
Math and trigonometrySECReturns the secant of an angle2013
Math and trigonometrySECHReturns the hyperbolic secant of an angle2013
Date and timeSECOND Converts a serial number to a second
Math and trigonometrySERIESSUM Returns the sum of a power series based on the formula
InformationSHEETReturns the sheet number of the referenced sheet2013
InformationSHEETSReturns the number of sheets in a reference2013
Math and trigonometrySIGN Returns the sign of a number
Math and trigonometrySIN Returns the sine of the given angle
Math and trigonometrySINH Returns the hyperbolic sine of a number
StatisticalSKEW Returns the skewness of a distribution
StatisticalSKEW.PReturns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean2013
FinancialSLN Returns the straight-line depreciation of an asset for one period
StatisticalSLOPE Returns the slope of the linear regression line
StatisticalSMALL Returns the k-th smallest value in a data set
Add-in and AutomationSQL.REQUEST 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 programming
Math and trigonometrySQRT Returns a positive square root
Math and trigonometrySQRTPI Returns the square root of (number * pi)
StatisticalSTANDARDIZE Returns a normalized value
CompatibilitySTDEV Estimates standard deviation based on a sample
StatisticalSTDEV.P Calculates standard deviation based on the entire population2010
StatisticalSTDEV.S Estimates standard deviation based on a sample2010
StatisticalSTDEVA Estimates standard deviation based on a sample, including numbers, text, and logical values
CompatibilitySTDEVP Calculates standard deviation based on the entire population

In Excel 2007, this is a Statistical function.
StatisticalSTDEVPA Calculates standard deviation based on the entire population, including numbers, text, and logical values
StatisticalSTEYX Returns the standard error of the predicted y-value for each x in the regression
TextSUBSTITUTE Substitutes new text for old text in a text string
Math and trigonometrySUBTOTAL Returns a subtotal in a list or database
Math and trigonometrySUM Adds its arguments
Math and trigonometrySUMIF Adds the cells specified by a given criteria
Math and trigonometrySUMIFS Adds the cells in a range that meet multiple criteria
Math and trigonometrySUMPRODUCT Returns the sum of the products of corresponding array components
Math and trigonometrySUMSQ Returns the sum of the squares of the arguments
Math and trigonometrySUMX2MY2 Returns the sum of the difference of squares of corresponding values in two arrays
Math and trigonometrySUMX2PY2 Returns the sum of the sum of squares of corresponding values in two arrays
Math and trigonometrySUMXMY2 Returns the sum of squares of differences of corresponding values in two arrays
LogicalSWITCHEvaluates 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.

This function isn't available in Excel 2016 for Mac.
2016
FinancialSYD Returns the sum-of-years' digits depreciation of an asset for a specified period
TextT Converts its arguments to text
Math and trigonometryTAN Returns the tangent of a number
Math and trigonometryTANH Returns the hyperbolic tangent of a number
FinancialTBILLEQ Returns the bond-equivalent yield for a Treasury bill
FinancialTBILLPRICE Returns the price per $100 face value for a Treasury bill
FinancialTBILLYIELD Returns the yield for a Treasury bill
StatisticalT.DIST Returns the Percentage Points (probability) for the Student t-distribution2010
StatisticalT.DIST.2T Returns the Percentage Points (probability) for the Student t-distribution2010
StatisticalT.DIST.RT Returns the Student's t-distribution2010
CompatibilityTDIST Returns the Student's t-distribution
TextTEXT Formats a number and converts it to text
TextTEXTJOINCombines 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.2016
Date and timeTIME Returns the serial number of a particular time
Date and timeTIMEVALUE Converts a time in the form of text to a serial number
StatisticalT.INV Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom2010
StatisticalT.INV.2T Returns the inverse of the Student's t-distribution2010
CompatibilityTINV Returns the inverse of the Student's t-distribution
Date and timeTODAY Returns the serial number of today's date
Lookup and referenceTRANSPOSE Returns the transpose of an array
StatisticalTREND Returns values along a linear trend
TextTRIM Removes spaces from text
StatisticalTRIMMEAN Returns the mean of the interior of a data set
LogicalTRUE Returns the logical value TRUE
Math and trigonometryTRUNC Truncates a number to an integer
StatisticalT.TEST Returns the probability associated with a Student's t-test2010
CompatibilityTTEST Returns the probability associated with a Student's t-test

In Excel 2007, this is a Statistical function.
InformationTYPE Returns a number indicating the data type of a value
TextUNICHARReturns the Unicode character that is references by the given numeric value2013
TextUNICODEReturns the number (code point) that corresponds to the first character of the text2013
TextUPPER Converts text to uppercase
TextVALUE Converts a text argument to a number
CompatibilityVAR Estimates variance based on a sample

In Excel 2007, this is a Statistical function.
StatisticalVAR.P Calculates variance based on the entire population2010
StatisticalVAR.S Estimates variance based on a sample2010
StatisticalVARA Estimates variance based on a sample, including numbers, text, and logical values
CompatibilityVARP Calculates variance based on the entire population

In Excel 2007, this is a Statistical function.
StatisticalVARPA Calculates variance based on the entire population, including numbers, text, and logical values
FinancialVDB Returns the depreciation of an asset for a specified or partial period by using a declining balance method
Lookup and referenceVLOOKUP Looks in the first column of an array and moves across the row to return the value of a cell
WebWEBSERVICEReturns data from a web service.
This function is not available in Excel Online.
2013
Date and timeWEEKDAY Converts a serial number to a day of the week
Date and timeWEEKNUM Converts a serial number to a number representing where the week falls numerically with a year
CompatibilityWEIBULL Calculates variance based on the entire population, including numbers, text, and logical values

In Excel 2007, this is a Statistical function.
StatisticalWEIBULL.DIST Returns the Weibull distribution2010
Date and timeWORKDAY Returns the serial number of the date before or after a specified number of workdays
Date and timeWORKDAY.INTLReturns 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 days2010
FinancialXIRR Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
FinancialXNPV Returns the net present value for a schedule of cash flows that is not necessarily periodic
LogicalXORReturns a logical exclusive OR of all arguments2013
Date and timeYEAR Converts a serial number to a year
Date and timeYEARFRAC Returns the year fraction representing the number of whole days between start_date and end_date
FinancialYIELD Returns the yield on a security that pays periodic interest
FinancialYIELDDISC Returns the annual yield for a discounted security; for example, a Treasury bill
FinancialYIELDMAT Returns the annual yield of a security that pays interest at maturity
StatisticalZ.TEST Returns the one-tailed probability-value of a z-test2010
CompatibilityZTEST Returns the one-tailed probability-value of a z-test

In Excel 2007, this is a Statistical function.

Leave a Comment