## Excel Functions

FunctionDescriptionCategory
A
ABSAbsolute valueMath Functions
ACCRINTCalculating accrued interestMath Functions
ACCRINTMaccrued interest that's paid periodicallyFinancial Functions
ACOSArccosine of a numberMath Functions
ACOSHInverse hyperbolic cosine of a numberMath Functions
ACOTThe angle returned is in radians between 0 and PI. * If "number" is not numeric, then #VALUEMath Functions
ACOTHOperates element-wise on arraysMath Functions
ADDRESSa reference, in text format, for a supplied row and column numberMath Functions
AGGREGATEComputes a single result from multiple input rowsReference Functions
AMORDEGRCCalculate the depreciation of an asset for each accounting periodMath Functions
AMORLINCCalculates the prorated linear depreciation of an asset for each accounting periodFinancial Functions
ANDTests a number of user-defined conditions and TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwiseLogical Functions
ARABICConverts a Roman numeral to an Arabic numeral (New in Excel 2013)Miscellaneous
AREASthe number of areas in a supplied rangeMiscellaneous
ASINthe Arcsine of a numberReference Functions
ASINHthe Inverse Hyperbolic Sine of a numberMath Functions
ATANthe Arctangent of a given numberMath Functions
ATAN2the Arctangent of a given pair of x and y coordinatesMath Functions
ATANHthe Inverse Hyperbolic Tangent of a given numberMath Functions
AVEDEVthe average of the absolute deviations of data points from their meanMath Functions
AVERAGEthe Average of a list of supplied numbersStatistical Functions
AVERAGEAthe Average of a list of supplied numbers, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1Math Functions
AVERAGEIFCalculates the Average of the cells in a supplied range, that satisfy a given criteria (New in Excel 2007)Math Functions
AVERAGEIFSCalculates the Average of the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007)Math Functions
B
BAHTTEXTConverts a number, plus the suffix "Baht" into Thai texttext Functions
BASEConverts a number into a text representation, with the supplied base (New in Excel 2013)Math Functions
BESSELICalculates the modified Bessel function In(x)Miscellaneous
BESSELKCalculates the modified Bessel function Kn(x)Engineering Functions
BESSELYCalculates the modified Bessel function Yn(x)Engineering Functions
BETA.DISTthe cumulative beta distribution function or the beta probability density function (New in Excel 2010 - replaces the Betadist function)Engineering Functions
BETA.INVthe inverse of the cumulative beta probability density function (New in Excel 2010 - replaces the Betainv function)Statistical Functions
BETADISTthe cumulative beta probability density function (Replaced by Beta.Dist function in Excel 2010)Statistical Functions
BETAINVthe inverse of the cumulative beta probability density function (Replaced by Beta.Inv function in Excel 2010)Statistical Functions
BIN2DECConverts a binary number to a decimalStatistical Functions
BIN2HEXConverts a binary number to hexadecimalEngineering Functions
BIN2OCTConverts a binary number to octalEngineering Functions
BINOM.DISTthe individual term binomial distribution probability (New in Excel 2010 - replaces the Binomdist function)Engineering Functions
BINOM.DIST.RANGEthe probability of a trial result using a binomial distribution (New in Excel 2013)Statistical Functions
BINOM.INVthe smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (New in Excel 2010 - replaces the Critbinom function)Statistical Functions
BINOMDISTthe individual term binomial distribution probability (Replaced by Binom.Dist function in Excel 2010)Statistical Functions
BITANDa Bitwise 'And' of two numbers (New in Excel 2013)Statistical Functions
BITLSHIFTa number shifted left by a specified number of bits (New in Excel 2013)Engineering Functions
BITORa Bitwise 'Or' of two numbers (New in Excel 2013)Engineering Functions
BITRSHIFTa number shifted right by a specified number of bits (New in Excel 2013)Engineering Functions
BITXORa Bitwise 'Exclusive Or' of two numbers (New in Excel 2013)Engineering Functions
C
CEILINGRounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a multiple of significanceMath Functions
CEILING.MATHRounds a number up to the nearest integer or to the nearest multiple of significance (New in Excel 2013)Math Functions
CEILING.PRECISERounds a number up, regardless of the sign of the number, to a multiple of significance (New in Excel 2010)Math Functions
CELLinformation about the contents, formatting or location of a given cellInformation Functions
CHARthe character that corresponds to a supplied numeric valuetext Functions
CHI.INV.RTthe inverse of the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chiinv function)Statistical Functions
CHIDISTthe right-tailed probability of the chi-squared distribution (Replaced by Chisq.Dist.Rt function in Excel 2010)Statistical Functions
CHIINVthe inverse of the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Inv.Rt function in Excel 2010)Statistical Functions
CHISQ.DISTthe chi-squared distribution (probability density or cumulative distribution function) (New in Excel 2010)Statistical Functions
CHISQ.DIST.RTthe right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chidist function)Statistical Functions
CHISQ.INVthe inverse of the left-tailed probability of the chi-squared distribution (New in Excel 2010)Statistical Functions
CHISQ.TESTthe chi-squared statistical test for independence (New in Excel 2010 - replaces the Chitest function)Statistical Functions
CHITESTthe chi-squared statistical test for independence (Replaced by Chisq.Test function in Excel 2010)Statistical Functions
CHOOSEone of a list of values, depending on the value of a supplied index numberStatistical Functions
CLEANRemoves all non-printable characters from a supplied text stringtext Functions
CODEthe numeric code for the first character of a supplied stringtext Functions
COLUMNthe column number of a supplied range, or of the current cellReference Functions
COLUMNSthe number of columns in a supplied rangeReference Functions
COMBINthe number of combinations (without repetitions) for a given number of objectsReference Functions
COMBINAthe number of combinations (with repetitions) for a given number of items (New in Excel 2013)Miscellaneous
COMPLEXConverts user-supplied real and imaginary coefficients into a complex numberMiscellaneous
CONCATJoins together two or more text strings (New in Excel 2016 (not Excel 2016 for Mac) - replaces the Concatenate function)text Functions
CONCATENATEJoins together two or more text strings (Replaced by the Concat function in Excel 2016)text Functions
CONFIDENCEthe confidence interval for a population mean, using a normal distribution (Replaced by Confidence.Norm function in Excel 2010)Statistical Functions
CONFIDENCE.NORMthe confidence interval for a population mean, using a normal distribution (New in Excel 2010 - replaces the Confidence function)Statistical Functions
CONFIDENCE.Tthe confidence interval for a population mean, using a Student's t distribution (New in Excel 2010)Statistical Functions
CONVERTConverts a number from one measurement system to anotherStatistical Functions
CORRELthe correlation coefficient between two sets of valuesStatistical Functions
COSthe Cosine of a given angleStatistical Functions
COSHthe hyperbolic cosine of a numberStatistical Functions
COTthe cotangent of an angle (New in Excel 2013)Math Functions
COTHthe hyperbolic cotangent of an angle (New in Excel 2013)Math Functions
COUNTthe number of numerical values in a supplied set of cells or valuesMath Functions
COUNTAthe number of non-blanks in a supplied set of cells or valuesMath Functions
COUNTBLANKthe number of blank cells in a supplied rangeReference Functions
COUNTIFCount the number of cells (of a supplied range), that satisfy a given criteriaMath Functions
COUNTIFSMultiple cells evaluation of range), that satisfy a set of given criteria (New in Excel 2007)Math Functions
COUPDAYBSCalculates the number of days from the beginning of the coupon period to the settlement dateMath Functions
COUPDAYSCalculates the number of days in the coupon period that contains the settlement dateFinancial Functions
COUPDAYSNCCalculates the number of days from the settlement date to the next coupon dateFinancial Functions
COUPNCDthe next coupon date after the settlement dateFinancial Functions
COUPNUMthe number of coupons payable between the settlement date and maturity dateFinancial Functions
COUPPCDthe previous coupon date, before the settlement dateFinancial Functions
COVARpopulation covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (Replaced by Covariance.P function in Excel 2010)Financial Functions
COVARIANCE.Ppopulation covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010 - replaces the Covar function)Statistical Functions
COVARIANCE.Ssample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010)Statistical Functions
CRITBINOMthe smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (Replaced by Binom.Inv function in Excel 2010)Statistical Functions
CSCthe cosecant of an angle (New in Excel 2013)Statistical Functions
CSCHthe hyperbolic cosecant of an angle (New in Excel 2013)Statistical Functions
CUBEKPIMEMBERa Key Performance Indicator (KPI) property and displays the KPI name in the cell (New in Excel 2007)Math Functions
CUBEMEMBERa member or tuple from the cube (New in Excel 2007)Cube Functions
CUBEMEMBERPROPERTYthe value of a member property from the cube (New in Excel 2007)Cube Functions
CUBERANKEDMEMBERthe nth, or ranked, member in a set (New in Excel 2007)Statistical Functions
CUBESETDefines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then that set to Microsoft Office Excel (New in Excel 2007)Cube Functions
CUBESETCOUNTthe number of items in a set (New in Excel 2007)Cube Functions
CUBEVALUEan aggregated value from the cube (New in Excel 2007)Cube Functions
CUMIPMTCalculates the cumulative interest paid between two specified periodsCube Functions
CUMPRINCCalculates the cumulative principal paid on a loan, between two specified periodsFinancial Functions
D
DATEReturns the current system dateDate and Time Functions
DATEDIFHidden function DATEDIF is not available in either the Excel 2016 Ribbon or the function helper. This calculates the number of days, months, or years between two dates.Date and Time Functions
DATEVALUEConverts a text string showing a date, to an integer that represents the date in Excel's date-time codeDate and Time Functions
DAVERAGECalculates the average of values in a field of a list or database, that satisfy specified conditionsDate and Time Functions
DAYthe day (of the month) from a user-supplied dateDate and Time Functions
DAYSthe number of days between 2 dates (New in Excel 2013)Date and Time Functions
DAYS360Calculates the number of days between 2 dates, based on a 360-day year (12 x 30 months)Date and Time Functions
DBCalculates the depreciation of an asset for a specified period, using the fixed-declining balance methodDate and Time Functions
DCOUNTthe number of cells containing numbers in a field of a list or database that satisfy specified conditionsFinancial Functions
DCOUNTAthe number of non-blank cells in a field of a list or database, that satisfy specified conditionsDatabase Functions
DDBCalculates the depreciation of an asset for a specified period, using the double-declining balance method, or some other user-specified methodDatabase Functions
DEC2BINConverts a decimal number to binaryFinancial Functions
DEC2HEXConverts a decimal number to hexadecimalMath Functions
DEC2OCTConverts a decimal number to octalMath Functions
DECIMALConverts a text representation of a number in a specified base into a decimal number (New in Excel 2013)Math Functions
DELTATests whether two supplied numbers are equalStatistical Functions
DEVSQthe sum of the squares of the deviations of a set of data points from their sample meanStatistical Functions
DGETa single value from a field of a list or database, that satisfy specified conditionsStatistical Functions
DISCCalculates the discount rate for a securityDatabase Functions
DMAXthe maximum value from a field of a list or database, that satisfy specified conditionsFinancial Functions
DMINthe minimum value from a field of a list or database, that satisfy specified conditionsDatabase Functions
DOLLARConverts a supplied number into text, using a currency formattext Functions
DOLLARDEConverts a dollar price expressed as a fraction, into a dollar price expressed as a decimalFinancial Functions
DOLLARFRConverts a dollar price expressed as a decimal, into a dollar price expressed as a fractionFinancial Functions
DPRODUCTCalculates the product of values in a field of a list or database, that satisfy specified conditionsFinancial Functions
DSTDEVCalculates the standard deviation (based on a sample of a population), of values in a field of a list or database, that satisfy specified conditionsDatabase Functions
DSTDEVPCalculates the standard deviation (based on an entire population), of values in a field of a list or database, that satisfy specified conditionsDatabase Functions
DSUMCalculates the sum of values in a field of a list or database, that satisfy specified conditionsDatabase Functions
DURATIONCalculates the Macauley duration of a security with an assumed par value of \$100Database Functions
DVARCalculates the variance (based on a sample of a population), of values in a field of a list or database, that satisfy specified conditionsFinancial Functions
DVARPCalculates the variance (based on an entire population), of values in a field of a list or database, that satisfy specified conditionsDatabase Functions
E
EDATEa date that is the specified number of months before or after an initial supplied start dateDate and Time Functions
EFFECTCalculates the effective annual interest rateDate and Time Functions
ENCODEURLa URL-encoded string (New in Excel 2013)Financial Functions
EOMONTHa date that is the last day of the month which is a specified number of months before or after an initial supplied start dateDate and Time Functions
ERFthe error function integrated between two supplied limitsDate and Time Functions
ERF.PRECISEthe error function integrated between 0 and a supplied limit (New in Excel 2010)Statistical Functions
ERFCthe complementary error function integrated between a supplied lower limit and infinityStatistical Functions
ERFC.PRECISEthe complementary error function integrated between a supplied lower limit and infinity (New in Excel 2010)Statistical Functions
ERROR.TYPETests a supplied value and an integer relating to the supplied value's error typeInformation Functions
EVENRounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next even numberInformation Functions
EXACTTests if two supplied text strings are exactly the same and if so, TRUE; Otherwise, FALSE. (case-sensitive)text Functions
EXPe raised to a given powerMath Functions
EXPON.DISTthe exponential distribution (New in Excel 2010 - replaces the Expondist function)Math Functions
EXPONDISTthe exponential distribution (Replaced by Expon.Dist function in Excel 2010)Statistical Functions
F
F.DISTthe F probability distribution (probability density or cumulative distribution function) (New in Excel 2010)Statistical Functions
F.DIST.RTthe right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Fdist function)Statistical Functions
F.INVthe inverse of the Cumulative F distribution (New in Excel 2010)Statistical Functions
F.INV.RTthe inverse of the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Finv function)Statistical Functions
F.TESTthe result of an F-Test for 2 supplied data sets (New in Excel 2010 - replaces the Ftest function)Statistical Functions
FACTthe Factorial of a given numberStatistical Functions
FACTDOUBLEthe Double Factorial of a given numberMath Functions
FALSESimply the logical value FALSELogical Functions
FDISTthe right-tailed F probability distribution for two data sets (Replaced by F.Dist.Rt function in Excel 2010)Statistical Functions
FILTERXMLdata from XML content, using a specified XPath (New in Excel 2013)Web Functions
FINDthe position of a supplied character or text string from within a supplied text string (case-sensitive)text Functions
FINVthe inverse of the right-tailed F probability distribution for two data sets (Replaced by F.Inv.Rt function in Excel 2010)Statistical Functions
FISHERthe Fisher transformationStatistical Functions
FISHERINVthe inverse of the Fisher transformationStatistical Functions
FIXEDRounds a supplied number to a specified number of decimal places, and then converts this into texttext Functions
FLOORRounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a multiple of significanceMath Functions
FLOOR.MATHRounds a number down, to the nearest integer or to the nearest multiple of significance (New in Excel 2013)Math Functions
FLOOR.PRECISERounds a number down, regardless of the sign of the number, to a multiple of significance (New in Excel 2010)Math Functions
FORECASTPredicts a future point on a linear trend line fitted to a supplied set of x- and y- valuesMath Functions
FORECAST.ETSPredicts a future value based based on historical values by using the AAA version of the Exponential Smoothing (ETS) algorithm (New in Excel 2016)Statistical Functions
FORECAST.ETS.CONFINTa confidence interval for a forecast value at a specified target date (New in Excel 2016)Statistical Functions
FORECAST.ETS.SEASONALITYthe length of the repetitive pattern Excel detects for a specified time series (New in Excel 2016)Statistical Functions
FORECAST.ETS.STATone or more statistical values as a result of time series forecasting (New in Excel 2016)Statistical Functions
FORECAST.LINEARPredicts a future point on a linear trend line fitted to a supplied set of x- and y- values (New in Excel 2016)Statistical Functions
FORMULATEXTa formula as a string (New in Excel 2013)Statistical Functions
FREQUENCYan array showing the number of values from a supplied array, which fall into specified rangesReference Functions
FTESTthe result of an F-Test for 2 supplied data sets (Replaced by F.Test function in Excel 2010)Statistical Functions
FVCalculates the future value of an investment with periodic constant payments and a constant interest rateStatistical Functions
FVSCHEDULECalculates the future value of an initial principal, after applying a series of compound interest rates
G
GAMMAReturn the gamma function value for a supplied number (New in Excel 2013)Statistical Functions
GAMMA.DISTthe gamma distribution (New in Excel 2010 - replaces the Gammadist function)Statistical Functions
GAMMA.INVthe inverse gamma cumulative distribution (New in Excel 2010 - replaces the Gammainv function)Statistical Functions
GAMMADISTthe gamma distribution (Replaced by Gamma.Dist function in Excel 2010)Statistical Functions
GAMMAINVthe inverse gamma cumulative distribution (Replaced by Gamma.Inv function in Excel 2010)Statistical Functions
GAMMALNCalculates the natural logarithm of the gamma function for a supplied valueStatistical Functions
GAMMALN.PRECISEthe natural logarithm of the gamma function for a supplied value (New in Excel 2010)Statistical Functions
GAUSSCalculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean (New in Excel 2013)Statistical Functions
GCDthe Greatest Common Divisor of two or more supplied numbersStatistical Functions
GEOMEANthe geometric mean of a set of supplied numbersMath Functions
GESTEPTests whether a number is greater than a supplied threshold valueMath Functions
GETPIVOTDATAExtracts data stored in a Pivot TableLogical Functions
GROWTHnumbers in a exponential growth trend, based on a set of supplied x- and y- valuesData Lookup Functions
H
HARMEANthe harmonic mean of a set of supplied numbersStatistical Functions
HEX2BINConverts a hexadecimal number to binaryStatistical Functions
HEX2DECConverts a hexadecimal number to a decimalStatistical Functions
HEX2OCTConverts a hexadecimal number to octalMath Functions
HLOOKUPLooks up a supplied value in the first row of a table, and the corresponding value from another rowMath Functions
HOURthe hour part of a user-supplied timeDate and Time Functions
HYPERLINKCreates a hyperlink to a document in a supplied locationDate and Time Functions
HYPGEOM.DISTthe hypergeometric distribution (New in Excel 2010 - replaces the Hypgeomdist function)Reference Functions
HYPGEOMDISTthe hypergeometric distribution (Replaced by Hypgeom.Dist function in Excel 2010)Statistical Functions
I
IFTests a user-defined condition and one result if the condition is TRUE, and another result if the condition is FALSELogical Functions
IFERRORTests if an initial supplied value (or expression) an error, and if so the function a supplied value; Otherwise the function the initial value. (New in Excel 2007)Logical Functions
IFNATests if an expression the #N/A error and if so, an alternative specified value; Otherwise the function the value of the supplied expression (New in Excel 2013)Logical Functions
IFSTests a number of supplied conditions and a result corresponding to the first condition that evaluates to TRUE (New in Excel 2016 - not available in Excel 2016 for Mac)Logical Functions
IMABSthe absolute value (the modulus) of a complex numberMath Functions
IMAGINARYthe imaginary coefficient of a complex numberEngineering Functions
IMARGUMENTthe argument Ã¢â€¢Â¬ÃƒÂ¿ (an angle expressed in radians) of a complex numberEngineering Functions
IMCONJUGATEthe complex conjugate of a complex numberEngineering Functions
IMCOSthe cosine of a complex numberEngineering Functions
IMCOSHthe hyperbolic cosine of a complex number (New in Excel 2013)Engineering Functions
IMCOTthe cotangent of a complex number (New in Excel 2013)Engineering Functions
IMCSCthe cosecant of a complex number (New in Excel 2013)Engineering Functions
IMCSCHthe hyperbolic cosecant of a complex number (New in Excel 2013)Engineering Functions
IMDIVthe quotient of two supplied complex numbersEngineering Functions
IMEXPthe exponential of a complex numberEngineering Functions
IMLNthe natural logarithm of a complex numberEngineering Functions
IMLOG10the base-10 logarithm of a complex numberEngineering Functions
IMLOG2the base-2 logarithm of a complex numberEngineering Functions
IMPOWERCalculates a complex number raised to a supplied powerEngineering Functions
IMPRODUCTthe product of up to 255 supplied complex numbersEngineering Functions
IMREALthe real coefficient of a complex numberEngineering Functions
IMSECthe secant of a complex number (New in Excel 2013)Engineering Functions
IMSECHthe hyperbolic secant of a complex number (New in Excel 2013)Engineering Functions
IMSINthe sine of a complex numberEngineering Functions
IMSINHthe hyperbolic sine of a complex number (New in Excel 2013)Engineering Functions
IMSQRTthe square root of a complex numberEngineering Functions
IMSUBSubtracts two complex numbersEngineering Functions
IMSUMCalculates the sum of two complex numbersEngineering Functions
IMTANthe tangent of a complex number (New in Excel 2013)Engineering Functions
INDEXa reference to a cell (or range of cells) for requested rows and columns within a supplied rangeEngineering Functions
INDIRECTa cell or range reference that is represented by a supplied text stringReference Functions
INFOinformation about the current operating environmentInformation Functions
INTRounds a number down to the next integerInformation Functions
INTERCEPTCalculates the best fit regression line, through a supplied series of x- and y- values and the value at which this line intercepts the y-axisMath Functions
INTRATECalculates the interest rate for a fully invested securityFinancial Functions
IPMTCalculates the interest payment for a given period of an investment, with periodic constant payments and a constant interest rateFinancial Functions
IRRCalculates the internal rate of return for a series of cash flowsStatistical Functions
ISBLANKTests if a supplied cell is blank (empty), and if so, TRUE; Otherwise, FALSEInformation Functions
ISERRTests if an initial supplied value (or expression) an error (EXCEPT for the #N/A error) and if so, TRUE; Otherwise FALSEInformation Functions
ISERRORTests if an initial supplied value (or expression) an error and if so, TRUE; Otherwise FALSEInformation Functions
ISEVENTests if a supplied number (or expression) is an even number, and if so, TRUE; Otherwise, FALSE.Information Functions
ISFORMULATests if a supplied cell contains a formula and if so, TRUE; Otherwise, FALSE (New in Excel 2013)Information Functions
ISLOGICALTests if a supplied value is a logical value, and if so, TRUE; Otherwise, FALSEInformation Functions
ISNATests if an initial supplied value (or expression) the Excel #N/A error and if so, TRUE; Otherwise FALSEInformation Functions
ISNONTEXTTests if a supplied value is text, and if it is NOT, TRUE; Otherwise, FALSEInformation Functions
ISNUMBERTests if a supplied value is a number, and if so, TRUE; Otherwise, FALSEInformation Functions
ISO.CEILINGRounds a number up, regardless of the sign of the number, to a multiple of significance. (New in Excel 2010)Math Functions
ISODDTests if a supplied number (or expression) is an odd number, and if so, TRUE; Otherwise, FALSEInformation Functions
ISOWEEKNUMthe ISO week number of the year for a given date (New in Excel 2013)Date and Time Functions
ISPMTthe interest paid during a specified period of an investmentDate and Time Functions
ISREFTests if a supplied value is a reference, and if so, TRUE; Otherwise, FALSEInformation Functions
ISTEXTTests if a supplied value is text, and if so, TRUE; Otherwise, FALSEInformation Functions
K
KURTthe kurtosis of a data setMiscellaneous
L
LARGEthe kth largest value from a list of supplied numbers, for a given value kMath Functions
LCMthe Least Common Multiple of two or more supplied numbersMath Functions
LEFTa specified number of characters from the start of a supplied text stringtext Functions
LENthe length of a supplied text stringtext Functions
LINESTstatistical information describing the trend of the line of best fit, through a supplied series of x- and y- valuestext Functions
LNthe natural logarithm of a given numberStatistical Functions
LOGthe logarithm of a given number, to a specified baseMath Functions
LOG10the base 10 logarithm of a given numberMath Functions
LOGESTthe parameters of an exponential trend for a supplied set of x- and y- valuesMath Functions
LOGINVthe inverse of the lognormal distribution (Replaced by Lognorm.Inv function in Excel 2010)Statistical Functions
LOGNORM.DISTthe log-normal probability density function or the cumulative log- normal distribution (New in Excel 2010 - replaces the Lognormdist function)Statistical Functions
LOGNORM.INVthe inverse of the lognormal distribution (New in Excel 2010 - replaces the Loginv function)Statistical Functions
LOGNORMDISTthe cumulative log-normal distribution (Replaced by Lognorm.Dist function in Excel 2010)Statistical Functions
LOOKUPSearches for a specific value in one data vector, and a value from the corresponding position of a second data vectorStatistical Functions
LOWERConverts all characters in a supplied text string to lower casetext Functions
M
MATCHFinds the relative position of a value in a supplied arrayReference Functions
MAXthe largest value from a list of supplied numbersMath Functions
MAXAthe largest value from a list of supplied values, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1Math Functions
MAXIFSthe largest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2016 - not available in Excel 2016 for Mac)Math Functions
MDETERMthe matrix determinant of a supplied arrayMath Functions
MDURATIONCalculates the Macauley modified duration for a security with an assumed par value of \$100Statistical Functions
MEDIANthe Median (the middle value) of a list of supplied numbersFinancial Functions
MIDa specified number of characters from the middle of a supplied text stringtext Functions
MINthe smallest value from a list of supplied numberstext Functions
MINAthe smallest value from a list of supplied values, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1Math Functions
MINIFSthe smallest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2016 - not available in Excel 2016 for Mac)Math Functions
MINUTEthe minute part of a user-supplied timeDate and Time Functions
MINVERSEthe matrix inverse of a supplied arrayDate and Time Functions
MIRRCalculates the internal rate of return for a series of periodic cash flows, considering the cost of the investment and the interest on the reinvestment of cashStatistical Functions
MMULTthe matrix product of two supplied arraysFinancial Functions
MODthe remainder from a division between two supplied numbersMath Functions
MODEthe Mode (the most frequently occurring value) of a list of supplied numbers (Replaced by Mode.Sngl function in Excel 2010)Math Functions
MODE.MULTa vertical array of the most frequently occurring values in an array or range of data (New in Excel 2010)Math Functions
MODE.SNGLthe Mode (the most frequently occurring value) of a list of supplied numbers (New in Excel 2010 - replaces the Mode function)Statistical Functions
MONTHReturns the month (a number from 1 to 12) given a date valueDate and Time Functions
MROUNDRounds a number up or down, to the nearest multiple of significanceDate and Time Functions
MULTINOMIALthe Multinomial of a given set of numbersMath Functions
MUNITthe unit matrix for a specified dimension (New in Excel 2013)Math Functions
N
NConverts a non-number value to a number, a date to a serial number, the logical value TRUE to 1 and all other values to 0Information Functions
NAthe Excel #N/A errorInformation Functions
NEGBINOM.DISTthe negative binomial distribution (New in Excel 2010 - replaces the Negbinomdist function)Statistical Functions
NEGBINOMDISTthe negative binomial distribution (Replaced by Negbinom.Dist function in Excel 2010)Statistical Functions
NETWORKDAYSthe number of whole networkdays (excluding weekends & holidays), between two supplied datesStatistical Functions
NETWORKDAYS.INTLthe number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days (New in Excel 2010)Date and Time Functions
NOMINALCalculates the annual nominal interest rateDate and Time Functions
NORM.DISTthe normal cumulative distribution (New in Excel 2010 - replaces the Normdist function)Financial Functions
NORM.INVthe inverse of the normal cumulative distribution (New in Excel 2010 - replaces the Norminv function)Statistical Functions
NORM.S.DISTthe standard normal cumulative distribution (New in Excel 2010 - replaces the Normsdist function)Statistical Functions
NORM.S.INVthe inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsinv function)Statistical Functions
NORMDISTthe normal cumulative distribution (Replaced by Norm.Dist function in Excel 2010)Statistical Functions
NORMINVthe inverse of the normal cumulative distribution (Replaced by Norm.Inv function in Excel 2010)Statistical Functions
NORMSDISTthe standard normal cumulative distribution (Replaced by Norm.S.Dist function in Excel 2010)Statistical Functions
NORMSINVthe inverse of the standard normal cumulative distribution (Replaced by Norm.S.Inv function in Excel 2010)Statistical Functions
NOTa logical value that is the opposite of a user supplied logical value or expression. (i.e. FALSE is the supplied argument is TRUE and TRUE if the supplied argument is FALSE)Logical Functions
NOWReturns the current system date and timeDate and Time Functions
NPERthe number of periods for an investment with periodic constant payments and a constant interest rateDate and Time Functions
NPVCalculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and incomeFinancial Functions
NUMBERVALUEConverts text to a number, in a locale-independent way (New in Excel 2013)text Functions
O
OCT2BINConverts octal number to binaryStatistical Functions
OCT2DECConverts octal number to a decimalMath Functions
OCT2HEXConverts octal number to hexadecimalMath Functions
ODDRounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next odd numberMath Functions
ODDFPRICECalculates the price per \$100 face value of a security with an odd first periodMath Functions
ODDFYIELDCalculates the yield of a security with an odd first periodFinancial Functions
ODDLPRICECalculates the price per \$100 face value of a security with an odd last periodFinancial Functions
ODDLYIELDCalculates the yield of a security with an odd last periodFinancial Functions
OFFSETa reference to a range of cells that is a specified number of rows and columns from an initial supplied rangeFinancial Functions
ORTests a number of user-defined conditions and TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwiseLogical Functions
P
PDURATIONCalculates the number of periods required for an investment to reach a specified value (New in Excel 2013)Financial Functions
PEARSONthe Pearson product moment correlation coefficientFinancial Functions
PERCENTILEthe k'th percentile of values in a supplied range, where k is in the range 0 - 1 (inclusive) (Replaced by Percentile.Inc function in Excel 2010)Statistical Functions
PERCENTILE.EXCthe k'th percentile of values in a supplied range, where k is in the range 0 - 1 (exclusive) (New in Excel 2010)Statistical Functions
PERCENTILE.INCthe k'th percentile of values in a supplied range, where k is in the range 0 - 1 (inclusive) (New in Excel 2010 - replaces the Percentile function)Statistical Functions
PERCENTRANKthe rank of a value in a data set, as a percentage (0 - 1 inclusive) (Replaced by Percentrank.Inc function in Excel 2010)Statistical Functions
PERCENTRANK.EXCthe rank of a value in a data set, as a percentage (0 - 1 exclusive) (New in Excel 2010)Statistical Functions
PERCENTRANK.INCthe rank of a value in a data set, as a percentage (0 - 1 inclusive) (New in Excel 2010 - replaces the Percentrank function)Statistical Functions
PERMUTthe number of permutations for a given number of objectsStatistical Functions
PERMUTATIONAthe number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (New in Excel 2013)Miscellaneous
PHIthe value of the density function for a standard normal distribution, for a supplied number (New in Excel 2013)Statistical Functions
PIthe constant value of piStatistical Functions
PMTCalculates the payments required to reduce a loan, from a supplied present value to a specified future valueMath Functions
POISSONthe Poisson distribution (Replaced by Poisson.Dist function in Excel 2010)Statistical Functions
POISSON.DISTthe Poisson distribution (New in Excel 2010 - replaces the Poisson function)Statistical Functions
POWERthe result of a given number raised to a supplied powerStatistical Functions
PPMTCalculates the payment on the principal for a given investment, with periodic constant payments and a constant interest rateMath Functions
PRICECalculates the price per \$100 face value of a security that pays periodic interestFinancial Functions
PRICEDISCCalculates the price per \$100 face value of a discounted securityFinancial Functions
PRICEMATCalculates the price per \$100 face value of a security that pays interest at maturityFinancial Functions
PROBthe probablity that values in a supplied range are within given limitsFinancial Functions
PRODUCTthe product of a supplied list of numbersMath Functions
PROPERConverts all characters in a supplied text string to proper case (i.e. letters that do not follow another letter are upper case and all other characters are lower case)text Functions
PVCalculates the present value of an investment (i.e. the total amount that a series of future payments is worth now)Statistical Functions
Q
QUARTILEthe specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (Replaced by Quartile.Inc function in Excel 2010)Statistical Functions
QUARTILE.EXCthe specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (exclusive) (New in Excel 2010)Statistical Functions
QUARTILE.INCthe specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (New in Excel 2010 - replaces the Quartile function)Statistical Functions
QUOTIENTthe integer portion of a division between two supplied numbersStatistical Functions
R
RANDa random number between 0 and 1Math Functions
RANDBETWEENa random number between two given integersStatistical Functions
RANKthe statistical rank of a given value, within a supplied array of values (Replaced by Rank.Eq function in Excel 2010)Statistical Functions
RANK.AVGthe statistical rank of a given value, within a supplied array of values (if more than one value has same rank, the average rank is returned) (New in Excel 2010)Statistical Functions
RANK.EQthe Mode (the most frequently occurring value) of a list of supplied numbers (if more than one value has same rank, the top rank of that set is returned) (New in Excel 2010 - replaces the Rank function)Statistical Functions
RATECalculates the interest rate required to pay off a specified amount of a loan, or reach a target amount on an investment over a given periodStatistical Functions
RECEIVEDCalculates the amount received at maturity for a fully invested SecurityFinancial Functions
REPLACEReplaces all or part of a text string with another string (from a user supplied position)text Functions
REPTa string consisting of a supplied text string, repeated a specified number of timestext Functions
RIGHTa specified number of characters from the end of a supplied text stringtext Functions
ROMANa text string depicting the roman numeral for a given numberMiscellaneous
ROUNDRounds a number up or down, to a given number of digitsMiscellaneous
ROUNDDOWNRounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a given number of digitsStatistical Functions
ROUNDUPRounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a given number of digitsMath Functions
ROWthe row number of a supplied range, or of the current cellMath Functions
ROWSthe number of rows in a supplied rangeReference Functions
RRICalculates an equivalent interest rate for the growth of an investment (New in Excel 2013)Reference Functions
RSQthe square of the Pearson product moment correlation coefficientFinancial Functions
RTDRetrieves real-time data from a program that supports COM automationStatistical Functions
S
SEARCHthe position of a supplied character or text string from within a supplied text string (non-case-sensitive)text Functions
SECthe secant of an angle (New in Excel 2013)Statistical Functions
SECHthe hyperbolic secant of an angle (New in Excel 2013)Math Functions
SECONDthe seconds part of a user-supplied timeMath Functions
SERIESSUMthe sum of a power seriesDate and Time Functions
SHEETthe sheet number relating to a supplied reference (New in Excel 2013)Information Functions
SHEETSthe number of sheets in a reference (New in Excel 2013)Information Functions
SIGNthe sign (+1, -1 or 0) of a supplied numberMath Functions
SINthe Sine of a given angleMath Functions
SINHthe Hyperbolic Sine of a numberMath Functions
SKEWthe skewness of a distributionMath Functions
SKEW.Pthe skewness of a distribution based on a population (New in Excel 2013)Statistical Functions
SLNthe straight-line depreciation of an asset for one periodStatistical Functions
SLOPEthe slope of the linear regression line through a supplied series of x- and y- valuesStatistical Functions
SMALLthe kth smallest value from a list of supplied numbers, for a given value kStatistical Functions
SQRTthe positive square root of a given numberMath Functions
SQRTPIthe square root of a supplied number multiplied by piMath Functions
STANDARDIZEa normalized valueMath Functions
STDEVthe standard deviation of a supplied set of values (which represent a sample of a population) (Replaced by Stdev.S function in Excel 2010)Statistical Functions
STDEV.Pthe standard deviation of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces the Stdevp function)Statistical Functions
STDEV.Sthe standard deviation of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces the Stdev function)Statistical Functions
STDEVAthe standard deviation of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1Statistical Functions
STDEVPthe standard deviation of a supplied set of values (which represent an entire population) (Replaced by Stdev.P function in Excel 2010)Statistical Functions
STDEVPAthe standard deviation of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1Statistical Functions
STEYXthe standard error of the predicted y-value for each x in the regression line for a set of supplied x- and y- valuesStatistical Functions
SUBSTITUTESubstitutes all occurrences of a search text string, within an original text string, with the supplied replacement texttext Functions
SUBTOTALPerforms a specified calculation (e.g. the sum, product, average, etc.) for a supplied set of valuesMath Functions
SUMthe sum of a supplied list of numbersMath Functions
SUMIFAdds the cells in a supplied range, that satisfy a given criteriaMath Functions
SUMIFSAdds the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007)Math Functions
SUMPRODUCTthe sum of the products of corresponding values in two or more supplied arraysMath Functions
SUMSQthe sum of the squares of a supplied list of numbersMath Functions
SUMX2MY2the sum of the difference of squares of corresponding values in two supplied arraysMath Functions
SUMX2PY2the sum of the sum of squares of corresponding values in two supplied arraysMath Functions
SUMXMY2the sum of squares of differences of corresponding values in two supplied arraysMath Functions
SWITCHCompares a number of supplied values to a supplied test expression and a result corresponding to the first value that matches the test expression (New in Excel 2016 - not available in Excel 2016 for Mac)Logical Functions
SYDthe sum-of-years' digits depreciation of an asset for a specified periodFinancial Functions
T
TTests whether a supplied value is text and if so, the supplied text; If not, an empty text stringtext Functions
T.DISTthe Student's T-distribution (probability density or cumulative distribution function) (New in Excel 2010)Statistical Functions
T.DIST.2Tthe two-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function)Statistical Functions
T.DIST.RTthe right-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function)Statistical Functions
T.INVthe left-tailed inverse of the Student's T-distribution (New in Excel 2010)Statistical Functions
T.INV.2Tthe two-tailed inverse of the Student's T-distribution (New in Excel 2010 - replaces the Tinv function)Statistical Functions
T.TESTthe probability associated with a Student's T-Test (New in Excel 2010 - replaces the Ttest function)Statistical Functions
TANthe Tangent of a given angleStatistical Functions
TANHthe Hyperbolic Tangent of a given numberMath Functions
TBILLEQCalculates the bond-equivalent yield for a treasury billMath Functions
TBILLPRICECalculates the price per \$100 face value for a treasury billFinancial Functions
TBILLYIELDCalculates the yield for a treasury billFinancial Functions
TDISTthe Student's T-distribution (Replaced by T.Dist.2t & T.Dist.Rt functions in Excel 2010)Financial Functions
TEXTConverts a supplied value into text, using a user-specified formattext Functions
TEXTJOINJoins together two or more text strings, separated by a delimiter (New in Excel 2016 - not available in Excel 2016 for Mac)text Functions
TIMEa time, from a user-supplied hour, minute and secondDate and Time Functions
TIMEVALUEConverts a text string showing a time, to a decimal that represents the time in ExcelDate and Time Functions
TINVthe two-tailed inverse of the Student's T-distribution (Replaced by T.Inv.2t function in Excel 2010)Date and Time Functions
TODAYtoday's dateStatistical Functions
TRANSPOSEPerforms a transpose transformation on a range of cells (i.e. transforms a horizontal range of cells into a vertical range and vice versa)Date and Time Functions
TRENDCalculates the trend line through a given set of y-values and additional y-values for a supplied set of new x-valuesReference Functions
TRIMRemoves all spaces from a test string except for single spaces between words. When TRIM does not remove Non-Breaking spaces, use this TRIM(SUBSTITUTE(D1,CHAR(160),CHAR(32)))text Functions
TRIMMEANthe mean of the interior of a supplied set of valuesStatistical Functions
TRUESimply the logical value TRUELogical Functions
TRUNCTruncates a number towards zero (i.e. rounds a positive number down and a negative number up), to the next integer.text Functions
TTESTthe probability associated with a Student's T-Test (Replaced by T.Test function in Excel 2010)Math Functions
TYPEinformation about the data type of a supplied valueInformation Functions
U
UNICHARthe Unicode character that is referenced by the given numeric value (New in Excel 2013)text Functions
UNICODEthe number (code point) corresponding to the first character of a supplied text string (New in Excel 2013)text Functions
UPPERConverts all characters in a supplied text string to upper casetext Functions
V
VALUEConverts a text string into a numeric valuetext Functions
VARthe variance of a supplied set of values (which represent a sample of a population) (Replaced by Var.S function in Excel 2010)Statistical Functions
VAR.Pthe variance of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces the Varp function)Statistical Functions
VAR.Sthe variance of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces the Var function)Statistical Functions
VARAthe variance of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1Statistical Functions
VARPthe variance of a supplied set of values (which represent an entire population) (Replaced by Var.P function in Excel 2010)Statistical Functions
VARPAthe variance of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1Statistical Functions
VDBthe depreciation of an asset for a specified period, (including partial periods), using the double-declining balance method or another user-specified methodStatistical Functions
VLOOKUPLooks up a supplied value in the first column of a table, and the corresponding value from another columnData Lookup Functions
W
WEBSERVICEdata from a web service on the Internet or Intranet (New in Excel 2013)Web Functions
WEEKDAYReturns a number representing the day of the week, given a date valueDate and Time Functions
WEEKNUMan integer representing the week number (from 1 to 53) of the year from a user-supplied dateDate and Time Functions
WEIBULLthe Weibull distribution (Replaced by Weibull.Dist function in Excel 2010)Statistical Functions
WEIBULL.DISTthe Weibull distribution (New in Excel 2010 - replaces the Weibull function)Statistical Functions
WORKDAYa date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start dateStatistical Functions
WORKDAY.INTLa date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date, using supplied parameters to specify weekend days (New in Excel 2010)Date and Time Functions
X
XIRRCalculates the internal rate of return for a schedule of cash flowsFinancial Functions
XNPVCalculates the net present value for a schedule of cash flowsFinancial Functions
XORa logical Exclusive Or of all arguments (New in Excel 2013)Logical Functions
Y
YEARReturns a four-digit year (a number from 1900 to 9999) given a date valueDate and Time Functions
YEARFRACCalculates the fraction of the year represented by the number of whole days between two datesDate and Time Functions
YIELDCalculates the yield of a security that pays periodic interestDate and Time Functions
YIELDDISCCalculates the annual yield of a discounted securityFinancial Functions
YIELDMATCalculates the annual yield of a security that pays interest at maturityFinancial Functions
Z
Z.TESTthe one-tailed probability value of a z-test (New in Excel 2010 - replaces the Ztest function)Statistical Functions