Built-In Excel Functions List

This page lists the current, built-in Excel Functions, grouped by category. If you know the name of the function you are interested in, you may prefer to select from the alphabetical functions list. Alternatively, select from the groups of functions below, to go to a full function description, including examples of use, related tips & tricks and common errors.

Excel Built-In Function Categories:
Text FunctionsLogical Functions
Information FunctionsDate and Time Functions
Lookup and Reference FunctionsMath and Trig Functions
Statistical FunctionsDatabase Functions
Financial FunctionsEngineering Functions
Cube FunctionsWeb Functions

Excel Text Functions

Functions to Remove Extra Characters
CLEANRemoves all non-printable characters from a supplied text string
TRIMRemoves duplicate spaces, and spaces at the start and end of a text string
Functions to Convert Excel Data Types
BAHTTEXTConverts a number, plus the suffix "Baht" into Thai text
DOLLARConverts a supplied number into text, using a currency format
FIXEDRounds a supplied number to a specified number of decimal places, and then converts this into text
TEXTConverts a supplied value into text, using a user-specified format
VALUEConverts a text string into a numeric value
NUMBERVALUEConverts text to a number, in a locale-independent way (New in Excel 2013)
Functions to Convert Between Upper & Lower Case
LOWERConverts all characters in a supplied text string to lower case
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)
UPPERConverts all characters in a supplied text string to upper case
Replacing / Substituting Parts of a Text String
REPLACEReplaces all or part of a text string with another string (from a user supplied position)
SUBSTITUTESubstitutes all occurrences of a search text string, within an original text string, with the supplied replacement text
Cutting Up & Piecing Together Text Strings
CONCATENATEJoins together two or more text strings
LEFTReturns a specified number of characters from the start of a supplied text string
MIDReturns a specified number of characters from the middle of a supplied text string
RIGHTReturns a specified number of characters from the end of a supplied text string
REPTReturns a string consisting of a supplied text string, repeated a specified number of times
Information Functions
LENReturns the length of a supplied text string
FINDReturns the position of a supplied character or text string from within a supplied text string (case-sensitive)
SEARCHReturns the position of a supplied character or text string from within a supplied text string (non-case-sensitive)
EXACTTests if two supplied text strings are exactly the same and if so, returns TRUE; Otherwise, returns FALSE. (case-sensitive)
TTests whether a supplied value is text and if so, returns the supplied text; If not, returns an empty text string.
Converting Between Characters & Numeric Codes
CHARReturns the character that corresponds to a supplied numeric value
CODEReturns the numeric code for the first character of a supplied string
UNICHARReturns the Unicode character that is referenced by the given numeric value (New in Excel 2013)
UNICODEReturns the number (code point) corresponding to the first character of a supplied text string (New in Excel 2013)


Excel Logical Functions

Boolean Operator Functions
ANDTests a number of user-defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise
ORTests a number of user-defined conditions and returns TRUE if ANYof the conditions evaluate to TRUE, or FALSE otherwise
XORReturns a logical Exclusive Or of all arguments (New in Excel 2013)
NOTReturns a logical value that is the opposite of a user supplied logical value or expression
(ie. returns FALSE is the supplied argument is TRUE and returns TRUE if the supplied argument is FALSE)
Conditional Functions
IFTests a user-defined condition and returns one result if the condition is TRUE, and another result if the condition is FALSE
IFERRORTests if an initial supplied value (or expression) returns an error, and if so the function returns a supplied value; Otherwise the function returns the initial value. (New in Excel 2007)
IFNATests if an expression returns the #N/A error and if so, returns an alternative specified value; Otherwise the function returns the value of the supplied expression (New in Excel 2013)
Functions Returning Constant Values
TRUESimply returns the logical value TRUE
FALSESimply returns the logical value FALSE


Excel Information Functions

Error Information Functions
ISERRORTests if an initial supplied value (or expression) returns an error and if so, returns TRUE; Otherwise returns FALSE
ISERRTests if an initial supplied value (or expression) returns an error (EXCEPT for the #N/A error) and if so, returns TRUE; Otherwise returns FALSE
ISNATests if an initial supplied value (or expression) returns the Excel #N/A error and if so, returns TRUE; Otherwise returns FALSE
ERROR.TYPETests a supplied value and returns an integer relating to the supplied value's error type
Numerical Information Functions
ISNUMBERTests if a supplied value is a number, and if so, returns TRUE; Otherwise, returns FALSE.
ISEVENTests if a supplied number (or expression) is an even number, and if so, returns TRUE; Otherwise, returns FALSE.
ISODDTests if a supplied number (or expression) is an odd number, and if so, returns TRUE; Otherwise, returns FALSE.
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 0
Function Returning a Constant Value
NAReturns the Excel #N/A error
Other Data Type Functions
ISBLANKTests if a supplied cell is blank (empty), and if so, returns TRUE; Otherwise, returns FALSE
ISLOGICALTests if a supplied value is a logical value, and if so, returns TRUE; Otherwise, returns FALSE
ISTEXTTests if a supplied value is text, and if so, returns TRUE; Otherwise, returns FALSE
ISNONTEXTTests if a supplied value is text, and if it is NOT, returns TRUE; Otherwise, returns FALSE
ISREFTests if a supplied value is a reference, and if so, returns TRUE; Otherwise, returns FALSE
ISFORMULATests if a supplied cell contains a formula and if so, returns TRUE; Otherwise, returns FALSE (New in Excel 2013)
TYPEReturns information about the data type of a supplied value
General Information Functions
CELLReturns information about the contents, formatting or location of a given cell
SHEETReturns the sheet number relating to a supplied reference (New in Excel 2013)
SHEETSReturns the number of sheets in a reference (New in Excel 2013)
INFOReturns information about the the current operating environment


Excel Date and Time Functions

Before using the Date and Time Excel Functions, it is advised that you ensure you have a clear understanding of the way Excel stores Dates and Times - For details, see the Excel Dates and Times pages.

Creating Dates & Times
DATEReturns a date, from a user-supplied year, month and day
TIMEReturns a time, from a user-supplied hour, minute and second
DATEVALUEConverts a text string showing a date, to an integer that represents the date in Excel's date-time code
TIMEVALUEConverts a text string showing a time, to a decimal that represents the time in Excel
Current Date & Time
NOWReturns the current date & time
TODAYReturns today's date
Extracting The Components of a Time
HOURReturns the hour part of a user-supplied time
MINUTEReturns the minute part of a user-supplied time
SECONDReturns the seconds part of a user-supplied time
Extracting The Components of a Date
DAYReturns the day (of the month) from a user-supplied date
MONTHReturns the month from a user-supplied date
YEARReturns the year from a user-supplied date
WEEKNUMReturns an integer representing the week number (from 1 to 53) of the year from a user-supplied date
ISOWEEKNUMReturns the ISO week number of the year for a given date (New in Excel 2013)
WEEKDAYReturns an integer representing the day of the week for a supplied date
Performing Calculations with Dates
EDATEReturns a date that is the specified number of months before or after an initial supplied start date
EOMONTHReturns a date that is the last day of the month which is a specified number of months before or after an initial supplied start date
WORKDAYReturns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date
WORKDAY.INTLReturns a 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)
DAYSCalculates the number of days between 2 dates (New in Excel 2013)
DAYS360Calculates the number of days between 2 dates, based on a 360-day year (12 x 30 months)
NETWORKDAYSReturns the number of whole networkdays (excluding weekends & holidays), between two supplied dates
NETWORKDAYS.INTLReturns the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days (New in Excel 2010)
YEARFRACCalculates the fraction of the year represented by the number of whole days between two dates


Excel Lookup and Reference Functions

Data Lookup Functions
HLOOKUPLooks up a supplied value in the first row of a table, and returns the corresponding value from another row
VLOOKUPLooks up a supplied value in the first column of a table, and returns the corresponding value from another column
LOOKUPSearches for a specific value in one data vector, and returns a value from the corresponding position of a second data vector
GETPIVOTDATAExtracts data stored in a Pivot Table
CHOOSEReturns one of a list of values, depending on the value of a supplied index number
MATCHFinds the relative position of a value in a supplied array
Row / Column / Area Information
ROWReturns the row number of a supplied range, or of the current cell
COLUMNReturns the column number of a supplied range, or of the current cell
ROWSReturns the number of rows in a supplied range
COLUMNSReturns the number of columns in a supplied range
AREASReturns the number of areas in a supplied range
Functions To Return References to Cell Ranges
ADDRESSReturns a reference, in text format, for a supplied row and column number
INDEXReturns a reference to a cell (or range of cells) for requested rows and columns within a supplied range
INDIRECTReturns a cell or range reference that is represented by a supplied text string
OFFSETReturns a reference to a range of cells that is a specified number of rows and columns from an initial supplied range
Other
HYPERLINKCreates a hyperlink to a document in a supplied location.
TRANSPOSEPerforms a transpose transformation on a range of cells (ie. transforms a horizontal range of cells into a vertical range and vice versa)
RTDRetrieves real-time data from a program that supports COM automation
FORMULATEXTReturns a formula as a string (New in Excel 2013)


Excel Math and Trig Functions

Basic Numeric Information
ABSReturns the absolute value (ie. the modulus) of a supplied number
SIGNReturns the sign (+1, -1 or 0) of a supplied number
GCDReturns the Greatest Common Divisor of two or more supplied numbers
LCMReturns the Least Common Multiple of two or more supplied numbers
Basic Mathematical Operations
SUMReturns the sum of a supplied list of numbers
PRODUCTReturns the product of a supplied list of numbers
POWERReturns the result of a given number raised to a supplied power
SQRTReturns the positive square root of a given number
QUOTIENTReturns the integer portion of a division between two supplied numbers
MODReturns the remainder from a division between two supplied numbers
AGGREGATEPerforms a specified calculation (eg. the sum, product, average, etc.) for a list or database, with the option to ignore hidden rows and error values (New in Excel 2010)
SUBTOTALPerforms a specified calculation (eg. the sum, product, average, etc.) for a supplied set of values
Rounding Functions
CEILINGRounds a number away from zero (ie. rounds a positive number up and a negative number down), to a multiple of significance
CEILING.PRECISERounds a number up, regardless of the sign of the number, to a multiple of significance (New in Excel 2010)
ISO.CEILINGRounds a number up, regardless of the sign of the number, to a multiple of significance. (New in Excel 2010)
CEILING.MATHRounds a number up to the nearest integer or to the nearest multiple of significance (New in Excel 2013)
EVENRounds a number away from zero (ie. rounds a positive number up and a negative number down), to the next even number
FLOORRounds a number towards zero, (ie. rounds a positive number down and a negative number up), to a multiple of significance
FLOOR.PRECISERounds a number down, regardless of the sign of the number, to a multiple of significance (New in Excel 2010)
FLOOR.MATHRounds a number down, to the nearest integer or to the nearest multiple of significance (New in Excel 2013)
INTRounds a number down to the next integer
MROUNDRounds a number up or down, to the nearest multiple of significance
ODDRounds a number away from zero (ie. rounds a positive number up and a negative number down), to the next odd number
ROUNDRounds a number up or down, to a given number of digits
ROUNDDOWNRounds a number towards zero, (ie. rounds a positive number down and a negative number up), to a given number of digits
ROUNDUPRounds a number away from zero (ie. rounds a positive number up and a negative number down), to a given number of digits
TRUNCTruncates a number towards zero (ie. rounds a positive number down and a negative number up), to the next integer.
Matrix Functions
MDETERMReturns the matrix determinant of a supplied array
MINVERSEReturns the matrix inverse of a supplied array
MMULTReturns the matrix product of two supplied arrays
MUNITReturns the unit matrix for a specified dimension (New in Excel 2013)
Random Numbers
RANDReturns a random number between 0 and 1
RANDBETWEENReturns a random number between two given integers
Conditional Sums
SUMIFAdds the cells in a supplied range, that satisfy a given criteria
SUMIFSAdds the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007)
Advanced Mathematical Operations
SUMPRODUCTReturns the sum of the products of corresponding values in two or more supplied arrays
SUMSQReturns the sum of the squares of a supplied list of numbers
SUMX2MY2Returns the sum of the difference of squares of corresponding values in two supplied arrays
SUMX2PY2Returns the sum of the sum of squares of corresponding values in two supplied arrays
SUMXMY2Returns the sum of squares of differences of corresponding values in two supplied arrays
SERIESSUMReturns the sum of a power series
Trigonometry Functions
PIReturns the constant value of pi
SQRTPIReturns the square root of a supplied number multiplied by pi
DEGREESConverts Radians to Degrees
RADIANSConverts Degrees to Radians
COSReturns the Cosine of a given angle
ACOSReturns the Arccosine of a number
COSHReturns the hyperbolic cosine of a number
ACOSHReturns the inverse hyperbolic cosine of a number
SECReturns the secant of an angle (New in Excel 2013)
SECHReturns the hyperbolic secant of an angle (New in Excel 2013)
SINReturns the Sine of a given angle
ASINReturns the Arcsine of a number
SINHReturns the Hyperbolic Sine of a number
ASINHReturns the Inverse Hyperbolic Sine of a number
CSCReturns the cosecant of an angle (New in Excel 2013)
CSCHReturns the hyperbolic cosecant of an angle (New in Excel 2013)
TANReturns the Tangent of a given angle
ATANReturns the Arctangent of a given number
ATAN2Returns the Arctangent of a given pair of x and y coordinates
TANHReturns the Hyperbolic Tangent of a given number
ATANHReturns the Inverse Hyperbolic Tangent of a given number
COTReturns the cotangent of an angle (New in Excel 2013)
COTHReturns the hyperbolic cotangent of an angle (New in Excel 2013)
ACOTReturns the arccotangent of a number (New in Excel 2013)
ACOTHReturns the hyperbolic arccotangent of a number (New in Excel 2013)
Exponentials & Logarithms
EXPReturns e raised to a given power
LNReturns the natural logarithm of a given number
LOGReturns the logarithm of a given number, to a specified base
LOG10Returns the base 10 logarithm of a given number
Factorials
FACTReturns the Factorial of a given number
FACTDOUBLEReturns the Double Factorial of a given number
MULTINOMIALReturns the Multinomial of a given set of numbers
Miscellaneous
BASEConverts a number into a text representation, with the supplied base (New in Excel 2013)
DECIMALConverts a text representation of a number in a specified base into a decimal number (New in Excel 2013)
COMBINReturns the number of combinations for a given number of objects
COMBINAReturns the number of combinations (with repetitions) for a given number of items (New in Excel 2013)
ARABICConverts a Roman numeral to an Arabic numeral (New in Excel 2013)
ROMANReturns a text string depicting the roman numeral for a given number


Excel Statistical Functions

Finding the Largest & Smallest Values
MAXReturns the largest value from a list of supplied numbers
MAXAReturns the 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 1
MINReturns the smallest value from a list of supplied numbers
MINAReturns the 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 1
LARGEReturns the Kth LARGEST value from a list of supplied numbers, for a given value K
SMALLReturns the Kth SMALLEST value from a list of supplied numbers, for a given value K
Counting Cells
COUNTReturns the number of numerical values in a supplied set of cells or values
COUNTAReturns the number of non-blanks in a supplied set of cells or values
COUNTBLANKReturns the number of blank cells in a supplied range
COUNTIFReturns the number of cells (of a supplied range), that satisfy a given criteria
COUNTIFSReturns the number of cells (of a supplied range), that satisfy a set of given criteria (New in Excel 2007)
Averages, Frequency & Rank
AVERAGEReturns the Average of a list of supplied numbers
AVERAGEAReturns the 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 1
AVERAGEIFCalculates the Average of the cells in a supplied range, that satisfy a given criteria (New in Excel 2007)
AVERAGEIFSCalculates the Average of the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007)
MEDIANReturns the Median (the middle value) of a list of supplied numbers
MODEReturns the Mode (the most frequently occurring value) of a list of supplied numbers (Replaced by MODE.SNGL function in Excel 2010)
MODE.SNGLReturns the Mode (the most frequently occurring value) of a list of supplied numbers (New in Excel 2010 - replaces MODE function)
MODE.MULTReturns a vertical array of the most frequently occurring values in an array or range of data (New in Excel 2010)
GEOMEANReturns the geometric mean of a set of supplied numbers
HARMEANReturns the harmonic mean of a set of supplied numbers
TRIMMEANReturns the mean of the interior of a supplied set of values
FREQUENCYReturns an array showing the number of values from a supplied array, which fall into specified ranges
RANKReturns the statistical rank of a given value, within a supplied array of values (Replaced by RANK.EQ function in Excel 2010)
RANK.EQReturns the 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 RANK function)
RANK.AVGReturns the 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)
KURTReturns the kurtosis of a data set
PERCENTILEReturns the 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)
PERCENTILE.INCReturns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (inclusive) (New in Excel 2010 - replaces PERCENTILE function)
PERCENTILE.EXCReturns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (exclusive) (New in Excel 2010)
PERCENTRANKReturns the rank of a value in a data set, as a percentage (0 - 1 inclusive) (Replaced by PERCENTRANK.INC function in Excel 2010)
PERCENTRANK.INCReturns the rank of a value in a data set, as a percentage (0 - 1 inclusive) (New in Excel 2010 - replaces PERCENTRANK function)
PERCENTRANK.EXCReturns the rank of a value in a data set, as a percentage (0 - 1 exclusive) (New in Excel 2010)
QUARTILEReturns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (Replaced by QUARTILE.INC function in Excel 2010)
QUARTILE.INCReturns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (New in Excel 2010 - replaces QUARTILE function)
QUARTILE.EXCReturns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (exclusive) (New in Excel 2010)
Deviation & Variance
AVEDEVReturns the average of the absolute deviations of data points from their mean
STDEVReturns the standard deviation of a supplied set of values (which represent a sample of a population) (Replaced by STDEV.S function in Excel 2010)
STDEV.SReturns the standard deviation of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces STDEV function)
STDEVAReturns the 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 1
STDEVPReturns the standard deviation of a supplied set of values (which represent an entire population) (Replaced by STDEV.P function in Excel 2010)
STDEV.PReturns the standard deviation of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces STDEVP function)
STDEVPAReturns the 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 1
VARReturns the variance of a supplied set of values (which represent a sample of a population) (Replaced by VAR.S function in Excel 2010)
VAR.SReturns the variance of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces VAR function)
VARAReturns the 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 1
VARPReturns the variance of a supplied set of values (which represent an entire population) (Replaced by VAR.P function in Excel 2010)
VAR.PReturns the variance of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces VARP function)
VARPAReturns the 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 1
COVARReturns population covariance (ie. the average of the products of deviations for each pair within two supplied data sets) (Replaced by COVARIANCE.P function in Excel 2010)
COVARIANCE.PReturns population covariance (ie. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010 - replaces COVAR function)
COVARIANCE.SReturns sample covariance (ie. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010)
CONFIDENCEReturns the confidence interval for a population mean, using a normal distribution (Replaced by CONFIDENCE.NORM function in Excel 2010)
CONFIDENCE.NORMReturns the confidence interval for a population mean, using a normal distribution (New in Excel 2010 - replaces CONFIDENCE function)
CONFIDENCE.TReturns the confidence interval for a population mean, using a Student's t distribution (New in Excel 2010)
DEVSQReturns the sum of the squares of the deviations of a set of data points from their sample mean
Trend Line Functions
FORECASTPredicts a future point on a linear trend line fitted to a supplied set of x- and y- values
INTERCEPTCalculates the best fit regression line, through a supplied series of x- and y- values and returns the value at which this line intercepts the y-axis
LINESTReturns statistical information describing the trend of the line of best fit, through a supplied series of x- and y- values
SLOPEReturns the slope of the linear regression line through a supplied series of x- and y- values
TRENDCalculates the trend line through a given set of y-values and returns additional y-values for a supplied set of new x-values
GROWTHReturns numbers in a exponential growth trend, based on a set of supplied x- and y- values
LOGESTReturns the parameters of an exponential trend for a supplied set of x- and y- values
STEYXReturns the standard error of the predicted y-value for each x in the regression line for a set of supplied x- and y- values
Miscellaneous
PERMUTReturns the number of permutations for a given number of objects
PERMUTATIONAReturns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (New in Excel 2013)
Distribution & Tests of Probability
BETADISTReturns the cumulative beta probability density function (Replaced by BETA.DIST function in Excel 2010)
BETA.DISTReturns the cumulative beta distribution function or the beta probability density function (New in Excel 2010 - replaces BETADIST function)
BETAINVReturns the inverse of the cumulative beta probability density function (Replaced by BETA.INV function in Excel 2010)
BETA.INVReturns the inverse of the cumulative beta probability density function (New in Excel 2010 - replaces BETAINV function)
BINOMDISTReturns the individual term binomial distribution probability (Replaced by BINOM.DIST function in Excel 2010)
BINOM.DISTReturns the individual term binomial distribution probability (New in Excel 2010 - replaces BINOMDIST function)
BINOM.DIST.RANGEReturns the probability of a trial result using a binomial distribution (New in Excel 2013)
NEGBINOMDISTReturns the negative binomial distribution (Replaced by NEGBINOM.DIST function in Excel 2010)
NEGBINOM.DISTReturns the negative binomial distribution (New in Excel 2010 - replaces NEGBINOMDIST function)
CRITBINOMReturns the 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)
BINOM.INVReturns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (New in Excel 2010 - replaces CRITBINOM function)
CHIDISTReturns the right-tailed probability of the chi-squared distribution (Replaced by CHISQ.DIST.RT function in Excel 2010)
CHISQ.DIST.RTReturns the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces CHIDIST function)
CHISQ.DISTReturns the chi-squared distribution (probability density or cumulative distribution function) (New in Excel 2010)
CHIINVReturns the inverse of the right-tailed probability of the chi-squared distribution (Replaced by CHISQ.INV.RT function in Excel 2010)
CHISQ.INV.RTReturns the inverse of the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces CHIINV function)
CHISQ.INVReturns the inverse of the left-tailed probability of the chi-squared distribution (New in Excel 2010)
CHITESTReturns the chi-squared statistical test for independence (Replaced by CHISQ.TEST function in Excel 2010)
CHISQ.TESTReturns the chi-squared statistical test for independence (New in Excel 2010 - replaces CHITEST function)
CORRELReturns the correlation coefficient between two sets of values
EXPONDISTReturns the exponential distribution (Replaced by EXPON.DIST function in Excel 2010)
EXPON.DISTReturns the exponential distribution (New in Excel 2010 - replaces EXPONDIST function)
FDISTReturns the right-tailed F probability distribution for two data sets (Replaced by F.DIST.RT function in Excel 2010)
F.DIST.RTReturns the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces FDIST function)
F.DISTReturns the F probability distribution (probability density or cumulative distribution function) (New in Excel 2010)
FINVReturns the inverse of the right-tailed F probability distribution for two data sets (Replaced by F.INV.RT function in Excel 2010)
F.INV.RTReturns the inverse of the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces FINV function)
F.INVReturns the inverse of the Cumulative F distribution (New in Excel 2010)
FISHERReturns the Fisher transformation
FISHERINVReturns the inverse of the Fisher transformation
FTESTReturns the result of an F-Test for 2 supplied data sets (Replaced by F.TEST function in Excel 2010)
F.TESTReturns the result of an F-Test for 2 supplied data sets (New in Excel 2010 - replaces FTEST function)
GAMMADISTReturns the gamma distribution (Replaced by GAMMA.DIST function in Excel 2010)
GAMMA.DISTReturns the gamma distribution (New in Excel 2010 - replaces GAMMADIST function)
GAMMAINVReturns the inverse gamma cumulative distribution (Replaced by GAMMA.INV function in Excel 2010)
GAMMA.INVReturns the inverse gamma cumulative distribution (New in Excel 2010 - replaces GAMMAINV function)
GAMMALNCalculates the natural logarithm of the gamma function for a supplied value
GAMMALN.PRECISEReturns the natural logarithm of the gamma function for a supplied value (New in Excel 2010)
GAMMAReturn the gamma function value for a supplied number (New in Excel 2013)
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)
HYPGEOMDISTReturns the hypergeometric distribution (Replaced by HYPGEOM.DIST function in Excel 2010)
HYPGEOM.DISTReturns the hypergeometric distribution (New in Excel 2010 - replaces HYPGEOMDIST function)
LOGNORMDISTReturns the cumulative log-normal distribution (Replaced by LOGNORM.DIST function in Excel 2010)
LOGNORM.DISTReturns the log-normal probability density function or the cumulative log- normal distribution (New in Excel 2010 - replaces LOGNORMDIST function)
LOGINVReturns the inverse of the lognormal distribution (Replaced by LOGNORM.INV function in Excel 2010)
LOGNORM.INVReturns the inverse of the lognormal distribution (New in Excel 2010 - replaces LOGINV function)
NORMDISTReturns the normal cumulative distribution (Replaced by NORM.DIST function in Excel 2010)
NORM.DISTReturns the normal cumulative distribution (New in Excel 2010 - replaces NORMDIST function)
NORMINVReturns the inverse of the normal cumulative distribution (Replaced by NORM.INV function in Excel 2010)
NORM.INVReturns the inverse of the normal cumulative distribution (New in Excel 2010 - replaces NORMINV function)
NORMSDISTReturns the standard normal cumulative distribution (Replaced by NORM.S.DIST function in Excel 2010)
NORM.S.DISTReturns the standard normal cumulative distribution (New in Excel 2010 - replaces NORMSDIST function)
NORMSINVReturns the inverse of the standard normal cumulative distribution (Replaced by NORM.S.INV function in Excel 2010)
NORM.S.INVReturns the inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces NORMSINV function)
PEARSONReturns the Pearson product moment correlation coefficient
RSQReturns the square of the Pearson product moment correlation coefficient
PHIReturns the value of the density function for a standard normal distribution, for a supplied number (New in Excel 2013)
POISSONReturns the Poisson distribution (Replaced by POISSON.DIST function in Excel 2010)
POISSON.DISTReturns the Poisson distribution (New in Excel 2010 - replaces POISSON function)
PROBReturns the probablity that values in a supplied range are within given limits
SKEWReturns the skewness of a distribution
SKEW.PReturns the skewness of a distribution based on a population (New in Excel 2013)
STANDARDIZEReturns a normalized value
TDISTReturns the Student's T-distribution (Replaced by T.DIST.2T & T.DIST.RT functions in Excel 2010)
T.DIST.2TReturns the two-tailed Student's T-distribution (New in Excel 2010 - replaces TDIST function)
T.DIST.RTReturns the right-tailed Student's T-distribution (New in Excel 2010 - replaces TDIST function)
T.DISTReturns the Student's T-distribution (probability density or cumulative distribution function) (New in Excel 2010)
TINVReturns the two-tailed inverse of the Student's T-distribution (Replaced by T.INV.2T function in Excel 2010)
T.INV.2TReturns the two-tailed inverse of the Student's T-distribution (New in Excel 2010 - replaces TINV function)
T.INVReturns the left-tailed inverse of the Student's T-distribution (New in Excel 2010)
TTESTReturns the probability associated with a Student's T-Test (Replaced by T.TEST function in Excel 2010)
T.TESTReturns the probability associated with a Student's T-Test (New in Excel 2010 - replaces TTEST function)
WEIBULLReturns the Weibull distribution (Replaced by WEIBULL.DIST function in Excel 2010)
WEIBULL.DISTReturns the Weibull distribution (New in Excel 2010 - replaces WEIBULL function)
ZTESTReturns the one-tailed probability value of a z-test (Replaced by Z.TEST function in Excel 2010)
Z.TESTReturns the one-tailed probability value of a z-test (New in Excel 2010 - replaces ZTEST function)


Excel Database Functions

Database Functions
DAVERAGECalculates the average of values in a field of a list or database, that satisfy specified conditions
DCOUNTReturns the number of cells containing numbers in a field of a list or database that satisfy specified conditions
DCOUNTAReturns the number of non-blank cells in a field of a list or database, that satisfy specified conditions
DGETReturns a single value from a field of a list or database, that satisfy specified conditions
DMAXReturns the maximum value from a field of a list or database, that satisfy specified conditions

DMINReturns the minimum value from a field of a list or database, that satisfy specified conditions

Database Functions
DPRODUCTCalculates the product of values in a field of a list or database, that satisfy specified conditions
DSTDEVCalculates the standard deviation (based on a sample of a population), of values in a field of a list or database, that satisfy specified conditions
DSTDEVPCalculates the standard deviation (based on an entire population), of values in a field of a list or database, that satisfy specified conditions
DSUMCalculates the sum of values in a field of a list or database, that satisfy specified conditions
DVARCalculates the variance (based on a sample of a population), of values in a field of a list or database, that satisfy specified conditions
DVARPCalculates the variance (based on an entire population), of values in a field of a list or database, that satisfy specified conditions


Excel Financial Functions

Investment Value Functions
FVCalculates the future value of an investment with periodic constant payments and a constant interest rate
FVSCHEDULECalculates the future value of an initial principal, after applying a series of compound interest rates
NPVCalculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and income
PVCalculates the present value of an investment (ie. the total amount that a series of future payments is worth now)
RECEIVEDCalculates the amount received at maturity for a fully invested Security
XNPVCalculates the net present value for a schedule of cash flows
Payment Functions
CUMIPMTCalculates the cumulative interest paid between two specified periods
CUMPRINCCalculates the cumulative principal paid on a loan, between two specified periods
IPMTCalculates the interest payment for a given period of an investment, with periodic constant payments and a constant interest rate
ISPMTReturns the interest paid during a specified period of an investment
PMTCalculates the payments required to reduce a loan, from a supplied present value to a specified future value
PPMTCalculates the payment on the principal for a given investment, with periodic constant payments and a constant interest rate
Duration Functions
COUPDAYBSCalculates the number of days from the beginning of the coupon period to the settlement date
COUPDAYSCalculates the number of days in the coupon period that contains the settlement date
COUPDAYSNCCalculates the number of days from the settlement date to the next coupon date
COUPNCDReturns the next coupon date after the settlement date
COUPNUMReturns the number of coupons payable between the settlement date and maturity date
COUPPCDReturns the previous coupon date, before the settlement date
DURATIONCalculates the Macauley duration of a security with an assumed par value of $100
MDURATIONCalculates the Macauley modified duration for a security with an assumed par value of $100
NPERReturns the number of periods for an investment with periodic constant payments and a constant interest rate
PDURATIONCalculates the number of periods required for an investment to reach a specified value (New in Excel 2013)
Yield Functions
YIELDCalculates the yield of a security that pays periodic interest
YIELDDISCCalculates the annual yield of a discounted security
YIELDMATCalculates the annual yield of a security that pays interest at maturity
ODDFYIELDCalculates the yield of a security with an odd first period
ODDLYIELDCalculates the yield of a security with an odd last period
TBILLEQCalculates the bond-equivalent yield for a treasury bill
TBILLYIELDCalculates the yield for a treasury bill
Internal Rate of Return Functions
IRRCalculates the internal rate of return for a series of cash flows
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 cash
XIRRCalculates the internal rate of return for a schedule of cash flows
Asset Depreciation Functions
AMORDEGRCCalculates the prorated linear depreciation of an asset for each accounting period (with depreciation coefficient applied, depending on the life of the asset)
AMORLINCCalculates the prorated linear depreciation of an asset for each accounting period
DBCalculates the depreciation of an asset for a specified period, using the fixed-declining balance method
DDBCalculates the depreciation of an asset for a specified period, using the double-declining balance method, or some other user-specified method
SLNReturns the straight-line depreciation of an asset for one period
SYDReturns the sum-of-years' digits depreciation of an asset for a specified period
VDBReturns the depreciation of an asset for a specified period, (including partial periods), using the double-declining balance method or another user-specified method
Interest Rate Functions
ACCRINTCalculates the accrued interest for a security that pays periodic interest
ACCRINTMCalculates the accrued interest for a security that pays interest at maturity
DISCCalculates the discount rate for a security
EFFECTCalculates the effective annual interest rate
INTRATECalculates the interest rate for a fully invested security
NOMINALCalculates the annual nominal interest rate
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 period
RRICalculates an equivalent interest rate for the growth of an investment (New in Excel 2013)
Dollar Conversion
DOLLARDEConverts a dollar price expressed as a fraction, into a dollar price expressed as a decimal
DOLLARFRConverts a dollar price expressed as a decimal, into a dollar price expressed as a fraction
Price Functions
PRICECalculates the price per $100 face value of a security that pays periodic interest
PRICEDISCCalculates the price per $100 face value of a discounted security
PRICEMATCalculates the price per $100 face value of a security that pays interest at maturity
ODDFPRICECalculates the price per $100 face value of a security with an odd first period
ODDLPRICECalculates the price per $100 face value of a security with an odd last period
TBILLPRICECalculates the price per $100 face value for a treasury bill


Excel Engineering Functions

Converting Between Units of Measurement
CONVERTConverts a number from one measurement system to another
Bessel Functions
BESSELICalculates the modified Bessel function In(x)
BESSELJCalculates the Bessel function Jn(x)
BESSELKCalculates the modified Bessel function Kn(x)
BESSELYCalculates the modified Bessel function Yn(x)
Converting Between Bases
BIN2DECConverts a binary number to a decimal
BIN2HEXConverts a binary number to hexadecimal
BIN2OCTConverts a binary number to octal
DEC2BINConverts a decimal number to binary
DEC2HEXConverts a decimal number to hexadecimal
DEC2OCTConverts a decimal number to octal
HEX2BINConverts a hexadecimal number to binary
HEX2DECConverts a hexadecimal number to a decimal
HEX2OCTConverts a hexadecimal number to octal
OCT2BINConverts octal number to binary
OCT2DECConverts octal number to a decimal
OCT2HEXConverts octal number to hexadecimal
The Error Function
ERFReturns the error function integrated between two supplied limits
ERF.PRECISEReturns the error function integrated between 0 and a supplied limit (New in Excel 2010)
ERFCReturns the complementary error function integrated between a supplied lower limit and infinity
ERFC.PRECISEReturns the complementary error function integrated between a supplied lower limit and infinity (New in Excel 2010)
Bitwise Functions
BITANDReturns a Bitwise 'And' of two numbers (New in Excel 2013)
BITORReturns a Bitwise 'Or' of two numbers (New in Excel 2013)
BITXORReturns a Bitwise 'Exclusive Or' of two numbers (New in Excel 2013)
BITLSHIFTReturns a number shifted left by a specified number of bits (New in Excel 2013)
BITRSHIFTReturns a number shifted right by a specified number of bits (New in Excel 2013)
Testing Numeric Values
DELTATests whether two supplied numbers are equal
GESTEPTests whether a number is greater than a supplied threshold value
Complex Numbers
COMPLEXConverts user-supplied real and imaginary coefficients into a complex number
IMABSReturns the absolute value (the modulus) of a complex number
IMAGINARYReturns the imaginary coefficient of a complex number
IMARGUMENTReturns the argument Θ (an angle expressed in radians) of a complex number
IMCONJUGATEReturns the complex conjugate of a complex number
IMCOSReturns the cosine of a complex number
IMCOSHReturns the hyperbolic cosine of a complex number (New in Excel 2013)
IMCOTReturns the cotangent of a complex number (New in Excel 2013)
IMCSCReturns the cosecant of a complex number (New in Excel 2013)
IMCSCHReturns the hyperbolic cosecant of a complex number (New in Excel 2013)
IMDIVReturns the quotient of two supplied complex numbers
IMEXPReturns the exponential of a complex number
IMLNReturns the natural logarithm of a complex number
IMLOG10Returns the base-10 logarithm of a complex number
IMLOG2Returns the base-2 logarithm of a complex number
IMPOWERCalculates a complex number raised to a supplied power
IMPRODUCTReturns the product of up to 255 supplied complex numbers
IMREALReturns the real coefficient of a complex number
IMSECReturns the secant of a complex number (New in Excel 2013)
IMSECHReturns the hyperbolic secant of a complex number (New in Excel 2013)
IMSINReturns the sine of a complex number
IMSINHReturns the hyperbolic sine of a complex number (New in Excel 2013)
IMSQRTReturns the square root of a complex number
IMSUBSubtracts two complex numbers
IMSUMCalculates the sum of two complex numbers
IMTANReturns the tangent of a complex number (New in Excel 2013)


Excel Cube Functions

The Excel Cube functions perform calculations and extract data from a cube, which is stored on an external SQL server. These functions are only supported with a connection to Microsoft SQL Server 2005 Analysis Services or later data source.

Cube Functions Cube Functions
CUBEKPIMEMBERReturns a Key Performance Indicator (KPI) property and displays the KPI name in the cell (New in Excel 2007)
CUBEMEMBERReturns a member or tuple from the cube (New in Excel 2007)
CUBEMEMBERPROPERTYReturns the value of a member property from the cube (New in Excel 2007)
CUBERANKEDMEMBERReturns the nth, or ranked, member in a set (New in Excel 2007)
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 returns that set to Microsoft Office Excel (New in Excel 2007)
CUBESETCOUNTReturns the number of items in a set (New in Excel 2007)
CUBEVALUEReturns an aggregated value from the cube (New in Excel 2007)


Excel Web Functions

Web Functions Web Functions
ENCODEURLReturns a URL-encoded string (New in Excel 2013)
FILTERXMLReturns data from XML content, using a specified XPath (New in Excel 2013)
WEBSERVICEReturns data from a web service on the Internet or Intranet (New in Excel 2013)


Excel Operators

Although the Excel Operators are not, strictly speaking, Excel Functions, a brief explanation of them is included in the following page:

Excel OperatorsExcel Mathematical Operators - used to perform basic Mathematical operations, such as addition, subtraction, multiplication, division and raising to a power,

OR

the & Excel Operator is used to concatenate text strings
Return to the ExcelFunctions.net Home Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net