Excel Functions in Alphabetical Order

An Excel function is a predefined formula that is meant to carry out a specific calculation. There are more than 470 functions available in Excel and they are grouped into different categories based on their purpose.

In this page you can find the complete list of Excel functions organised in their Alphabetical Order. You can also go through the Excel functions category wise.

FunctionCategoryPurpose
ABSMath and trigonometryReturns the absolute value of a number
ACCRINTFinancialReturns the accrued interest for a security that pays periodic interest
ACCRINTMFinancialReturns the accrued interest for a security that pays interest at maturity
ACOSMath and trigonometryReturns the arccosine of a number
ACOSHMath and trigonometryReturns the inverse hyperbolic cosine of a number
ACOTMath and trigonometryReturns the arccotangent of a number
ACOTHMath and trigonometryReturns the hyperbolic arccotangent of a number
AGGREGATEMath and trigonometryReturns an aggregate in a list or database
ADDRESSLookup and referenceReturns a reference as text to a single cell in a worksheet
AMORDEGRCFinancialReturns the depreciation for each accounting period by using a depreciation coefficient
AMORLINCFinancialReturns the depreciation for each accounting period
ANDLogicalReturns TRUE if all of its arguments are TRUE
ARABICMath and trigonometryConverts a Roman number to Arabic, as a number
AREASLookup and referenceReturns the number of areas in a reference
ASCTextChanges full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
ASINMath and trigonometryReturns the arcsine of a number
ASINHMath and trigonometryReturns the inverse hyperbolic sine of a number
ATANMath and trigonometryReturns the arctangent of a number
ATAN2Math and trigonometryReturns the arctangent from x- and y-coordinates
ATANHMath and trigonometryReturns the inverse hyperbolic tangent of a number
AVEDEVStatisticalReturns the average of the absolute deviations of data points from their mean
AVERAGEStatisticalReturns the average of its arguments
AVERAGEAStatisticalReturns the average of its arguments, including numbers, text, and logical values
AVERAGEIFStatisticalReturns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFSStatisticalReturns the average (arithmetic mean) of all cells that meet multiple criteria.
BAHTTEXTTextConverts a number to text, using the ß (baht) currency format
BASEMath and trigonometryConverts a number into a text representation with the given radix (base)
BESSELIEngineeringReturns the modified Bessel function In(x)
BESSELJEngineeringReturns the Bessel function Jn(x)
BESSELKEngineeringReturns the modified Bessel function Kn(x)
BESSELYEngineeringReturns the Bessel function Yn(x)
BETADISTCompatibilityReturns the beta cumulative distribution function
BETA.DISTStatisticalReturns the beta cumulative distribution function
BETAINVCompatibilityReturns the inverse of the cumulative distribution function for a specified beta distribution
BETA.INVStatisticalReturns the inverse of the cumulative distribution function for a specified beta distribution
BIN2DECEngineeringConverts a binary number to decimal
BIN2HEXEngineeringConverts a binary number to hexadecimal
BIN2OCTEngineeringConverts a binary number to octal
BINOMDISTCompatibilityReturns the individual term binomial distribution probability
BINOM.DISTStatisticalReturns the individual term binomial distribution probability
BINOM.DIST.RANGEStatisticalReturns the probability of a trial result using a binomial distribution
BINOM.INVStatisticalReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
BITANDEngineeringReturns a ‘Bitwise And’ of two numbers
BITLSHIFTEngineeringReturns a value number shifted left by shift_amount bits
BITOREngineeringReturns a bitwise OR of 2 numbers
BITRSHIFTEngineeringReturns a value number shifted right by shift_amount bits
BITXOREngineeringReturns a bitwise ‘Exclusive Or’ of two numbers
CALLAdd-in and AutomationCalls a procedure in a dynamic link library or code resource
CEILINGMath and trigonometryRounds a number to the nearest integer or to the nearest multiple of significance
CEILING.MATHMath and trigonometryRounds a number up, to the nearest integer or to the nearest multiple of significance
CEILING.PRECISEMath and trigonometryRounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
CELLInformationReturns information about the formatting, location, or contents of a cell
CHARTextReturns the character specified by the code number
CHIDISTCompatibilityReturns the one-tailed probability of the chi-squared distribution
CHIINVCompatibilityReturns the inverse of the one-tailed probability of the chi-squared distribution
CHITESTCompatibilityReturns the test for independence
CHISQ.DISTStatisticalReturns the cumulative beta probability density function
CHISQ.DIST.RTStatisticalReturns the one-tailed probability of the chi-squared distribution
CHISQ.INVStatisticalReturns the cumulative beta probability density function
CHISQ.INV.RTStatisticalReturns the inverse of the one-tailed probability of the chi-squared distribution
CHISQ.TESTStatisticalReturns the test for independence
CHOOSELookup and referenceChooses a value from a list of values
CLEANTextRemoves all nonprintable characters from text
CODETextReturns a numeric code for the first character in a text string
COLUMNLookup and referenceReturns the column number of a reference
COLUMNSLookup and referenceReturns the number of columns in a reference
COMBINMath and trigonometryReturns the number of combinations for a given number of objects
COMBINAMath and trigonometryReturns the number of combinations with repetitions for a given number of items
COMPLEXEngineeringConverts real and imaginary coefficients into a complex number
CONCATTextCombines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments.
CONCATENATETextJoins several text items into one text item
CONFIDENCECompatibilityReturns the confidence interval for a population mean
CONFIDENCE.NORMStatisticalReturns the confidence interval for a population mean
CONFIDENCE.TStatisticalReturns the confidence interval for a population mean, using a Student’s t distribution
CONVERTEngineeringConverts a number from one measurement system to another
CORRELStatisticalReturns the correlation coefficient between two data sets
COSMath and trigonometryReturns the cosine of a number
COSHMath and trigonometryReturns the hyperbolic cosine of a number
COTMath and trigonometryReturns the hyperbolic cosine of a number
COTHMath and trigonometryReturns the cotangent of an angle
COUNTStatisticalCounts how many numbers are in the list of arguments
COUNTAStatisticalCounts how many values are in the list of arguments
COUNTBLANKStatisticalCounts the number of blank cells within a range
COUNTIFStatisticalCounts the number of cells within a range that meet the given criteria
COUNTIFSStatisticalCounts the number of cells within a range that meet multiple criteria
COUPDAYBSFinancialReturns the number of days from the beginning of the coupon period to the settlement date
COUPDAYSFinancialReturns the number of days in the coupon period that contains the settlement date
COUPDAYSNCFinancialReturns the number of days from the settlement date to the next coupon date
COUPNCDFinancialReturns the next coupon date after the settlement date
COUPNUMFinancialReturns the number of coupons payable between the settlement date and maturity date
COUPPCDFinancialReturns the previous coupon date before the settlement date
COVARCompatibilityReturns covariance, the average of the products of paired deviations
COVARIANCE.PStatisticalReturns covariance, the average of the products of paired deviations
COVARIANCE.SStatisticalReturns the sample covariance, the average of the products deviations for each data point pair in two data sets
CRITBINOMCompatibilityReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
CSCMath and trigonometryReturns the cosecant of an angle
CSCHMath and trigonometryReturns the hyperbolic cosecant of an angle
CUBEKPIMEMBERCubeReturns 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.
CUBEMEMBERCubeReturns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.
CUBEMEMBERPROPERTYCubeReturns 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.
CUBERANKEDMEMBERCubeReturns 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.
CUBESETCubeDefines 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.
CUBESETCOUNTCubeReturns the number of items in a set.
CUBEVALUECubeReturns an aggregated value from a cube.
CUMIPMTFinancialReturns the cumulative interest paid between two periods
CUMPRINCFinancialReturns the cumulative principal paid on a loan between two periods
DATEDate and timeReturns the serial number of a particular date
DATEDIFDate and timeCalculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.
DATEVALUEDate and timeConverts a date in the form of text to a serial number
DAVERAGEDatabaseReturns the average of selected database entries
DAYDate and timeConverts a serial number to a day of the month
DAYSDate and timeReturns the number of days between two dates
DAYS360Date and timeCalculates the number of days between two dates based on a 360-day year
DBFinancialReturns the depreciation of an asset for a specified period by using the fixed-declining balance method
DBCSTextChanges half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
DCOUNTDatabaseCounts the cells that contain numbers in a database
DCOUNTADatabaseCounts nonblank cells in a database
DDBFinancialReturns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
DEC2BINEngineeringConverts a decimal number to binary
DEC2HEXEngineeringConverts a decimal number to hexadecimal
DEC2OCTEngineeringConverts a decimal number to octal
DECIMALMath and trigonometryConverts a text representation of a number in a given base into a decimal number
DEGREESMath and trigonometryConverts radians to degrees
DELTAEngineeringTests whether two values are equal
DEVSQStatisticalReturns the sum of squares of deviations
DGETDatabaseExtracts from a database a single record that matches the specified criteria
DISCFinancialReturns the discount rate for a security
DMAXDatabaseReturns the maximum value from selected database entries
DMINDatabaseReturns the minimum value from selected database entries
DOLLARTextConverts a number to text, using the $ (dollar) currency format
DOLLARDEFinancialConverts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
DOLLARFRFinancialConverts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
DPRODUCTDatabaseMultiplies the values in a particular field of records that match the criteria in a database
DSTDEVDatabaseEstimates the standard deviation based on a sample of selected database entries
DSTDEVPDatabaseCalculates the standard deviation based on the entire population of selected database entries
DSUMDatabaseAdds the numbers in the field column of records in the database that match the criteria
DURATIONFinancialReturns the annual duration of a security with periodic interest payments
DVARDatabaseEstimates variance based on a sample from selected database entries
DVARPDatabaseCalculates variance based on the entire population of selected database entries
EDATEDate and timeReturns the serial number of the date that is the indicated number of months before or after the start date
EFFECTFinancialReturns the effective annual interest rate
ENCODEURLWebReturns a URL-encoded string
EOMONTHDate and timeReturns the serial number of the last day of the month before or after a specified number of months
ERFEngineeringReturns the error function
ERF.PRECISEEngineeringReturns the error function
ERFCEngineeringReturns the complementary error function
ERFC.PRECISEEngineeringReturns the complementary ERF function integrated between x and infinity
ERROR.TYPEInformationReturns a number corresponding to an error type
EUROCONVERTAdd-in and AutomationConverts 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).
EVENMath and trigonometryRounds a number up to the nearest even integer
EXACTTextChecks to see if two text values are identical
EXPMath and trigonometryReturns e raised to the power of a given number
EXPON.DISTStatisticalReturns the exponential distribution
EXPONDISTCompatibilityReturns the exponential distribution
FACTMath and trigonometryReturns the factorial of a number
FACTDOUBLEMath and trigonometryReturns the double factorial of a number
FALSELogicalReturns the logical value FALSE
F.DISTStatisticalReturns the F probability distribution
FDISTCompatibilityReturns the F probability distribution
F.DIST.RTStatisticalReturns the F probability distribution
FILTER Lookup and referenceFilters a range of data based on criteria you define
FILTERXMLWebReturns specific data from the XML content by using the specified XPath
FIND, FINDBsTextFinds one text value within another (case-sensitive)
F.INVStatisticalReturns the inverse of the F probability distribution
F.INV.RTStatisticalReturns the inverse of the F probability distribution
FINVStatisticalReturns the inverse of the F probability distribution
FISHERStatisticalReturns the Fisher transformation
FISHERINVStatisticalReturns the inverse of the Fisher transformation
FIXEDTextFormats a number as text with a fixed number of decimals
FLOORCompatibilityRounds a number down, toward zero
FLOOR.MATHMath and trigonometryRounds a number down, to the nearest integer or to the nearest multiple of significance
FLOOR.PRECISEMath and trigonometryRounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
FORECASTStatisticalReturns a value along a linear trend
FORECAST.ETSStatisticalReturns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm
FORECAST.ETS.CONFINTStatisticalReturns a confidence interval for the forecast value at the specified target date
FORECAST.ETS.SEASONALITYStatisticalReturns the length of the repetitive pattern Excel detects for the specified time series
FORECAST.ETS.STATStatisticalReturns a statistical value as a result of time series forecasting
FORECAST.LINEARStatisticalReturns a future value based on existing values
FORMULATEXTLookup and referenceReturns the formula at the given reference as text
FREQUENCYStatisticalReturns a frequency distribution as a vertical array
F.TESTStatisticalReturns the result of an F-test
FTESTCompatibilityReturns the result of an F-test
FVFinancialReturns the future value of an investment
FVSCHEDULEFinancialReturns the future value of an initial principal after applying a series of compound interest rates
GAMMAStatisticalReturns the Gamma function value
GAMMA.DISTStatisticalReturns the gamma distribution
GAMMADISTCompatibilityReturns the gamma distribution
GAMMA.INVStatisticalReturns the inverse of the gamma cumulative distribution
GAMMAINVCompatibilityReturns the inverse of the gamma cumulative distribution
GAMMALNStatisticalReturns the natural logarithm of the gamma function, Γ(x)
GAMMALN.PRECISEStatisticalReturns the natural logarithm of the gamma function, Γ(x)
GAUSSStatisticalReturns 0.5 less than the standard normal cumulative distribution
GCDMath and trigonometryReturns the greatest common divisor
GEOMEANStatisticalReturns the geometric mean
GESTEPEngineeringTests whether a number is greater than a threshold value
GETPIVOTDATALookup and referenceReturns data stored in a PivotTable report
GROWTHStatisticalReturns values along an exponential trend
HARMEANStatisticalReturns the harmonic mean
HEX2BINEngineeringConverts a hexadecimal number to binary
HEX2DECEngineeringConverts a hexadecimal number to decimal
HEX2OCTEngineeringConverts a hexadecimal number to octal
HLOOKUPLookup and referenceLooks in the top row of an array and returns the value of the indicated cell
HOURDate and timeConverts a serial number to an hour
HYPERLINKLookup and referenceCreates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
HYPGEOM.DISTStatisticalReturns the hypergeometric distribution
HYPGEOMDISTCompatibilityReturns the hypergeometric distribution
IFLogicalSpecifies a logical test to perform
IFERRORLogicalReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
IFNALogicalReturns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
IFSLogicalChecks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
IMABSEngineeringReturns the absolute value (modulus) of a complex number
IMAGINARYEngineeringReturns the imaginary coefficient of a complex number
IMARGUMENTEngineeringReturns the argument theta, an angle expressed in radians
IMCONJUGATEEngineeringReturns the complex conjugate of a complex number
IMCOSEngineeringReturns the cosine of a complex number
IMCOSHEngineeringReturns the hyperbolic cosine of a complex number
IMCOTEngineeringReturns the cotangent of a complex number
IMCSCEngineeringReturns the cosecant of a complex number
IMCSCHEngineeringReturns the hyperbolic cosecant of a complex number
IMDIVEngineeringReturns the quotient of two complex numbers
IMEXPEngineeringReturns the exponential of a complex number
IMLNEngineeringReturns the natural logarithm of a complex number
IMLOG10EngineeringReturns the base-10 logarithm of a complex number
IMLOG2EngineeringReturns the base-2 logarithm of a complex number
IMPOWEREngineeringReturns a complex number raised to an integer power
IMPRODUCTEngineeringReturns the product of complex numbers
IMREALEngineeringReturns the real coefficient of a complex number
IMSECEngineeringReturns the secant of a complex number
IMSECHEngineeringReturns the hyperbolic secant of a complex number
IMSINEngineeringReturns the sine of a complex number
IMSINHEngineeringReturns the hyperbolic sine of a complex number
IMSQRTEngineeringReturns the square root of a complex number
IMSUBEngineeringReturns the difference between two complex numbers
IMSUMEngineeringReturns the sum of complex numbers
IMTANEngineeringReturns the tangent of a complex number
INDEXLookup and referenceUses an index to choose a value from a reference or array
INDIRECTLookup and referenceReturns a reference indicated by a text value
INFOInformationReturns information about the current operating environment
INTMath and trigonometryRounds a number down to the nearest integer
INTERCEPTStatisticalReturns the intercept of the linear regression line
INTRATEFinancialReturns the interest rate for a fully invested security
IPMTFinancialReturns the interest payment for an investment for a given period
IRRFinancialReturns the internal rate of return for a series of cash flows
ISBLANKInformationReturns TRUE if the value is blank
ISERRInformationReturns TRUE if the value is any error value except #N/A
ISERRORInformationReturns TRUE if the value is any error value
ISEVENInformationReturns TRUE if the number is even
ISFORMULAInformationReturns TRUE if there is a reference to a cell that contains a formula
ISLOGICALInformationReturns TRUE if the value is a logical value
ISNAInformationReturns TRUE if the value is the #N/A error value
ISNONTEXTInformationReturns TRUE if the value is not text
ISNUMBERInformationReturns TRUE if the value is a number
ISODDInformationReturns TRUE if the number is odd
ISREFInformationReturns TRUE if the value is a reference
ISTEXTInformationReturns TRUE if the value is text
ISO.CEILINGMath and trigonometryReturns a number that is rounded up to the nearest integer or to the nearest multiple of significance
ISOWEEKNUMDate and timeReturns the number of the ISO week number of the year for a given date
ISPMTFinancialCalculates the interest paid during a specific period of an investment
JISText   Changes half-width (single-byte) characters within a string to full-width (double-byte) characters
KURTStatisticalReturns the kurtosis of a data set
LARGEStatisticalReturns the k-th largest value in a data set
LCMMath and trigonometryReturns the least common multiple
LEFT, LEFTBsTextReturns the leftmost characters from a text value
LEN, LENBsTextReturns the number of characters in a text string
LINESTStatisticalReturns the parameters of a linear trend
LNMath and trigonometryReturns the natural logarithm of a number
LOGMath and trigonometryReturns the logarithm of a number to a specified base
LOG10Math and trigonometryReturns the base-10 logarithm of a number
LOGESTStatisticalReturns the parameters of an exponential trend
LOGINVCompatibilityReturns the inverse of the lognormal cumulative distribution
LOGNORM.DISTStatisticalReturns the cumulative lognormal distribution
LOGNORMDISTCompatibilityReturns the cumulative lognormal distribution
LOGNORM.INVStatisticalReturns the inverse of the lognormal cumulative distribution
LOOKUPLookup and referenceLooks up values in a vector or array
LOWERTextConverts text to lowercase
MATCHLookup and referenceLooks up values in a reference or array
MAXStatisticalReturns the maximum value in a list of arguments
MAXAStatisticalReturns the maximum value in a list of arguments, including numbers, text, and logical values
MAXIFSStatisticalReturns the maximum value among cells specified by a given set of conditions or criteria
MDETERMMath and trigonometryReturns the matrix determinant of an array
MDURATIONFinancialReturns the Macauley modified duration for a security with an assumed par value of $100
MEDIANStatisticalReturns the median of the given numbers
MID, MIDBsTextReturns a specific number of characters from a text string starting at the position you specify
MINStatisticalReturns the minimum value in a list of arguments
MINIFSStatisticalReturns the minimum value among cells specified by a given set of conditions or criteria.
MINAStatisticalReturns the smallest value in a list of arguments, including numbers, text, and logical values
MINUTEDate and timeConverts a serial number to a minute
MINVERSEMath and trigonometryReturns the matrix inverse of an array
MIRRFinancialReturns the internal rate of return where positive and negative cash flows are financed at different rates
MMULTMath and trigonometryReturns the matrix product of two arrays
MODMath and trigonometryReturns the remainder from division
MODECompatibilityReturns the most common value in a data set
MODE.MULTStatisticalReturns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
MODE.SNGLStatisticalReturns the most common value in a data set
MONTHDate and timeConverts a serial number to a month
MROUNDMath and trigonometryReturns a number rounded to the desired multiple
MULTINOMIALMath and trigonometryReturns the multinomial of a set of numbers
MUNITMath and trigonometryReturns the unit matrix or the specified dimension
NInformationReturns a value converted to a number
NAInformationReturns the error value #N/A
NEGBINOM.DISTStatisticalReturns the negative binomial distribution
NEGBINOMDISTCompatibilityReturns the negative binomial distribution
NETWORKDAYSDate and timeReturns the number of whole workdays between two dates
NETWORKDAYS.INTLDate and timeReturns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
NOMINALFinancialReturns the annual nominal interest rate
NORM.DISTStatisticalReturns the normal cumulative distribution
NORMDISTCompatibilityReturns the normal cumulative distribution
NORMINVStatisticalReturns the inverse of the normal cumulative distribution
NORM.INVCompatibilityReturns the inverse of the normal cumulative distribution
NORM.S.DISTStatisticalReturns the standard normal cumulative distribution
NORMSDISTCompatibilityReturns the standard normal cumulative distribution
NORM.S.INVStatisticalReturns the inverse of the standard normal cumulative distribution
NORMSINVCompatibilityReturns the inverse of the standard normal cumulative distribution
NOTLogicalReverses the logic of its argument
NOWDate and timeReturns the serial number of the current date and time
NPERFinancialReturns the number of periods for an investment
NPVFinancialReturns the net present value of an investment based on a series of periodic cash flows and a discount rate
NUMBERVALUETextConverts text to number in a locale-independent manner
OCT2BINEngineeringConverts an octal number to binary
OCT2DECEngineeringConverts an octal number to decimal
OCT2HEXEngineeringConverts an octal number to hexadecimal
ODDMath and trigonometryRounds a number up to the nearest odd integer
ODDFPRICEFinancialReturns the price per $100 face value of a security with an odd first period
ODDFYIELDFinancialReturns the yield of a security with an odd first period
ODDLPRICEFinancialReturns the price per $100 face value of a security with an odd last period
ODDLYIELDFinancialReturns the yield of a security with an odd last period
OFFSETLookup and referenceReturns a reference offset from a given reference
ORLogicalReturns TRUE if any argument is TRUE
PDURATIONFinancialReturns the number of periods required by an investment to reach a specified value
PEARSONStatisticalReturns the Pearson product moment correlation coefficient
PERCENTILE.EXCStatisticalReturns the k-th percentile of values in a range, where k is in the range 0..1, exclusive
PERCENTILE.INCStatisticalReturns the k-th percentile of values in a range
PERCENTILECompatibilityReturns the k-th percentile of values in a range
PERCENTRANK.EXCStatisticalReturns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
PERCENTRANK.INCStatisticalReturns the percentage rank of a value in a data set
PERCENTRANKCompatibilityReturns the percentage rank of a value in a data set
PERMUTStatisticalReturns the number of permutations for a given number of objects
PERMUTATIONAStatisticalReturns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHIStatisticalReturns the value of the density function for a standard normal distribution
PHONETICTextExtracts the phonetic (furigana) characters from a text string
PIMath and trigonometryReturns the value of pi
PMTFinancialReturns the periodic payment for an annuity
POISSON.DISTStatisticalReturns the Poisson distribution
POISSONCompatibilityReturns the Poisson distribution
POWERMath and trigonometryReturns the result of a number raised to a power
PPMTFinancialReturns the payment on the principal for an investment for a given period
PRICEFinancialReturns the price per $100 face value of a security that pays periodic interest
PRICEDISCFinancialReturns the price per $100 face value of a discounted security
PRICEMATFinancialReturns the price per $100 face value of a security that pays interest at maturity
PROBStatisticalReturns the probability that values in a range are between two limits
PRODUCTMath and trigonometryMultiplies its arguments
PROPERTextCapitalizes the first letter in each word of a text value
PVFinancialReturns the present value of an investment
QUARTILECompatibilityReturns the quartile of a data set
QUARTILE.EXCStatisticalReturns the quartile of the data set, based on percentile values from 0..1, exclusive
QUARTILE.INCStatisticalReturns the quartile of a data set
QUOTIENTMath and trigonometryReturns the integer portion of a division
RADIANSMath and trigonometryConverts degrees to radians
RANDMath and trigonometryReturns a random number between 0 and 1
RANDARRAYMath and trigonometryReturns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.
RANDBETWEENMath and trigonometryReturns a random number between the numbers you specify
RANK.AVGStatisticalReturns the rank of a number in a list of numbers
RANK.EQStatisticalReturns the rank of a number in a list of numbers
RANKCompatibilityReturns the rank of a number in a list of numbers
RATEFinancialReturns the interest rate per period of an annuity
RECEIVEDFinancialReturns the amount received at maturity for a fully invested security
REGISTER.IDAdd-in and AutomationReturns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered
REPLACE, REPLACEBsTextReplaces characters within text
REPTTextRepeats text a given number of times
RIGHT, RIGHTBsTextReturns the rightmost characters from a text value
ROMANMath and trigonometryConverts an arabic numeral to roman, as text
ROUNDMath and trigonometryRounds a number to a specified number of digits
ROUNDDOWNMath and trigonometryRounds a number down, toward zero
ROUNDUPMath and trigonometryRounds a number up, away from zero
ROWLookup and referenceReturns the row number of a reference
ROWSLookup and referenceReturns the number of rows in a reference
RRIFinancialReturns an equivalent interest rate for the growth of an investment
RSQStatisticalReturns the square of the Pearson product moment correlation coefficient
RTDLookup and referenceRetrieves real-time data from a program that supports COM automation
SEARCH, SEARCHBsTextFinds one text value within another (not case-sensitive)
SECMath and trigonometryReturns the secant of an angle
SECHMath and trigonometryReturns the hyperbolic secant of an angle
SECONDDate and timeConverts a serial number to a second
SEQUENCEMath and trigonometryGenerates a list of sequential numbers in an array, such as 1, 2, 3, 4
SERIESSUMMath and trigonometryReturns the sum of a power series based on the formula
SHEETInformationReturns the sheet number of the referenced sheet
SHEETSInformationReturns the number of sheets in a reference
SIGNMath and trigonometryReturns the sign of a number
SINMath and trigonometryReturns the sine of the given angle
SINHMath and trigonometryReturns the hyperbolic sine of a number
SKEWStatisticalReturns the skewness of a distribution
SKEW.PStatisticalReturns the skewness of a distribution based on a population
SLNFinancialReturns the straight-line depreciation of an asset for one period
SLOPEStatisticalReturns the slope of the linear regression line
SMALLStatisticalReturns the k-th smallest value in a data set
SORTLookup and referenceSorts the contents of a range or array
SORTBYLookup and referenceSorts the contents of a range or array based on the values in a corresponding range or array
SQRTMath and trigonometryReturns a positive square root
SQRTPIMath and trigonometryReturns the square root of (number * pi)
STANDARDIZEStatisticalReturns a normalized value
STDEVCompatibilityEstimates standard deviation based on a sample
STDEV.PStatisticalCalculates standard deviation based on the entire population
STDEV.SStatisticalEstimates standard deviation based on a sample
STDEVAStatisticalEstimates standard deviation based on a sample, including numbers, text, and logical values
STDEVPCompatibilityCalculates standard deviation based on the entire population
STDEVPAStatisticalCalculates standard deviation based on the entire population, including numbers, text, and logical values
STEYXStatisticalReturns the standard error of the predicted y-value for each x in the regression
SUBSTITUTETextSubstitutes new text for old text in a text string
SUBTOTALMath and trigonometryReturns a subtotal in a list or database
SUMMath and trigonometryAdds its arguments
SUMIFMath and trigonometryAdds the cells specified by a given criteria
SUMIFSMath and trigonometryAdds the cells in a range that meet multiple criteria
SUMPRODUCTMath and trigonometryReturns the sum of the products of corresponding array components
SUMSQMath and trigonometryReturns the sum of the squares of the arguments
SUMX2MY2Math and trigonometryReturns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2Math and trigonometryReturns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2Math and trigonometryReturns the sum of squares of differences of corresponding values in two arrays
SWITCHLogicalEvaluates 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.
SYDFinancialReturns the sum-of-years’ digits depreciation of an asset for a specified period
TTextConverts its arguments to text
TANMath and trigonometryReturns the tangent of a number
TANHMath and trigonometryReturns the hyperbolic tangent of a number
TBILLEQFinancialReturns the bond-equivalent yield for a Treasury bill
TBILLPRICEFinancialReturns the price per $100 face value for a Treasury bill
TBILLYIELDFinancialReturns the yield for a Treasury bill
T.DISTStatisticalReturns the Percentage Points (probability) for the Student t-distribution
T.DIST.2TStatisticalReturns the Percentage Points (probability) for the Student t-distribution
T.DIST.RTStatisticalReturns the Student’s t-distribution
TDISTCompatibilityReturns the Student’s t-distribution
TEXTTextFormats a number and converts it to text
TEXTJOINTextCombines 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.
TIMEDate and timeReturns the serial number of a particular time
TIMEVALUEDate and timeConverts a time in the form of text to a serial number
T.INVStatisticalReturns the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom
T.INV.2TStatisticalReturns the inverse of the Student’s t-distribution
TINVCompatibilityReturns the inverse of the Student’s t-distribution
TODAYDate and timeReturns the serial number of today’s date
TRANSPOSELookup and referenceReturns the transpose of an array
TRENDStatisticalReturns values along a linear trend
TRIMTextRemoves spaces from text
TRIMMEANStatisticalReturns the mean of the interior of a data set
TRUELogicalReturns the logical value TRUE
TRUNCMath and trigonometryTruncates a number to an integer
T.TESTStatisticalReturns the probability associated with a Student’s t-test
TTESTCompatibilityReturns the probability associated with a Student’s t-test
TYPEInformationReturns a number indicating the data type of a value
UNICHARTextReturns the Unicode character that is references by the given numeric value
UNICODETextReturns the number (code point) that corresponds to the first character of the text
UNIQUELookup and referenceReturns a list of unique values in a list or range
UPPERTextConverts text to uppercase
VALUETextConverts a text argument to a number
VARCompatibilityEstimates variance based on a sample
VAR.PStatisticalCalculates variance based on the entire population
VAR.SStatisticalEstimates variance based on a sample
VARAStatisticalEstimates variance based on a sample, including numbers, text, and logical values
VARPCompatibilityCalculates variance based on the entire population
VARPAStatisticalCalculates variance based on the entire population, including numbers, text, and logical values
VDBFinancialReturns the depreciation of an asset for a specified or partial period by using a declining balance method
VLOOKUPLookup and referenceLooks in the first column of an array and moves across the row to return the value of a cell
WEBSERVICEWebReturns data from a web service.
WEEKDAYDate and timeConverts a serial number to a day of the week
WEEKNUMDate and timeConverts a serial number to a number representing where the week falls numerically with a year
WEIBULLCompatibilityCalculates variance based on the entire population, including numbers, text, and logical values
WEIBULL.DISTStatisticalReturns the Weibull distribution
WORKDAYDate and timeReturns the serial number of the date before or after a specified number of workdays
WORKDAY.INTLDate and timeReturns 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 days
XIRRFinancialReturns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XLOOKUPLookup and referenceSearches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn’t exist, then XLOOKUP can return the closest (approximate) match. 
XMATCHLookup and referenceReturns the relative position of an item in an array or range of cells. 
XNPVFinancialReturns the net present value for a schedule of cash flows that is not necessarily periodic
XORLogicalReturns a logical exclusive OR of all arguments
YEARDate and timeConverts a serial number to a year
YEARFRACDate and timeReturns the year fraction representing the number of whole days between start_date and end_date
YIELDFinancialReturns the yield on a security that pays periodic interest
YIELDDISCFinancialReturns the annual yield for a discounted security; for example, a Treasury bill
YIELDMATFinancialReturns the annual yield of a security that pays interest at maturity
Z.TESTStatisticalReturns the one-tailed probability-value of a z-test
ZTESTStatisticalReturns the one-tailed probability-value of a z-test

Read about Excel Functions

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel