Function List
A complete list of all 480+ functions useable within Excel, grouped by category.
To find the function you're looking for, click one of the categories listed below to jump to that corresponding table. If you know the name of the function or part of the description, try pressing ctrl+F to search the entire page, if not, try search bar located at the top of the page.
Categories:
Add-in and Automation - Aids in the dynamic integration of external data sources
Cube - Retrieve values from data models to build customized reports without relying on pivot tables
Database - Used to manipulate and analyze data stores in lists or databases
Date and Time - Assists with manipulation and calculation of various dates and times
Engineering - Common engineering functions, and ability to convert between different bases and complex numbers
Financial - Basic financial calculations such as future value, discount rate, depreciation, and yield.
Information - Gives meta info from workbooks and compares logical values
Logical - Allows the use of logical operators like "If/And/Or/Xor" across a range of different criteria.
Lookup - Filters and returns specified data
Math and trigonometry - Commonly used mathematical functions and operators
Statistical - Provides statistical analysis tools to better understand correlations and deviations
Text - Gives control over any text related field, searching, converting, formatting, and editing
Web - Allows the collection of data from the web using xml and xpath
Add-in and Automation:
These functions aid in the dynamic integration with specific external data sources.
Title | Description |
|---|---|
CALL | Calls a procedure in a dynamic link library or code resource |
EUROCONVERT | Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation). |
REGISTER.ID | Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered |
Cube:
These functions are used to retrieve values from data models to build customized reports without relying on pivot tables. These are the base calculations and transformations done behind the scenes when a pivot table is created.
Title | Description |
|---|---|
CUBEKPIMEMBER | Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance. |
CUBEMEMBER | Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube. |
CUBEMEMBERPROPERTY | Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member. |
CUBERANKEDMEMBER | Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students. |
CUBESET | Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel. |
CUBESETCOUNT | Returns the number of items in a set. |
CUBEVALUE | Returns an aggregated value from a cube. |
Database:
The main functions used to manipulate and analyze data stores in lists or databases.
Title | Description |
|---|---|
DAVERAGE | Returns the average of selected database entries |
DCOUNT | Counts the cells that contain numbers in a database |
DCOUNTA | Counts nonblank cells in a database |
DGET | Extracts from a database a single record that matches the specified criteria |
DMAX | Returns the maximum value from selected database entries |
DMIN | Returns the minimum value from selected database entries |
DPRODUCT | Multiplies the values in a particular field of records that match the criteria in a database |
DSTDEV | Estimates the standard deviation based on a sample of selected database entries |
DSTDEVP | Calculates the standard deviation based on the entire population of selected database entries |
DSUM | Adds the numbers in the field column of records in the database that match the criteria |
DVAR | Estimates variance based on a sample from selected database entries |
DVARP | Calculates variance based on the entire population of selected database entries |
Date and Time:
These functions assists with manipulation and calculation of various dates and times.
Title | Description |
|---|---|
DATE | Returns the serial number of a particular date |
DATEDIF | Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. |
DATEVALUE | Converts a date in the form of text to a serial number |
DAY | Converts a serial number to a day of the month |
DAYS | Returns the number of days between two dates |
DAYS360 | Calculates the number of days between two dates based on a 360-day year |
EDATE | Returns the serial number of the date that is the indicated number of months before or after the start date |
EOMONTH | Returns the serial number of the last day of the month before or after a specified number of months |
HOUR | Converts a serial number to an hour |
ISOWEEKNUM | Returns the number of the ISO week number of the year for a given date |
MINUTE | Converts a serial number to a minute |
MONTH | Converts a serial number to a month |
Engineering:
Your most common engineering functions, giving you the ability to convert between different bases and complex numbers.
Title | Description |
|---|---|
BESSELI | Returns the modified Bessel function In(x) |
BESSELJ | Returns the Bessel function Jn(x) |
BESSELK | Returns the modified Bessel function Kn(x) |
BESSELY | Returns the Bessel function Yn(x) |
BIN2DEC | Converts a binary number to decimal |
BIN2HEX | Converts a binary number to hexadecimal |
BIN2OCT | Converts a binary number to octal |
BITAND | Returns a 'Bitwise And' of two numbers |
BITLSHIFT | Returns a value number shifted left by shift_amount bits |
BITOR | Returns a bitwise OR of 2 numbers |
BITRSHIFT | Returns a value number shifted right by shift_amount bits |
BITXOR | Returns a bitwise 'Exclusive Or' of two numbers |
Financial:
These are your basic financial functions, allowing you to calculate future/present value, discount rates, depreciation, different yields, and loan calculations.
Title | Description |
|---|---|
ACCRINT | Returns the accrued interest for a security that pays periodic interest |
ACCRINTM | Returns the accrued interest for a security that pays interest at maturity |
AMORDEGRC | Returns the depreciation for each accounting period by using a depreciation coefficient |
AMORLINC | Returns the depreciation for each accounting period |
COUPDAYBS | Returns the number of days from the beginning of the coupon period to the settlement date |
COUPDAYS | Returns the number of days in the coupon period that contains the settlement date |
COUPDAYSNC | Returns the number of days from the settlement date to the next coupon date |
COUPNCD | Returns the next coupon date after the settlement date |
COUPNUM | Returns the number of coupons payable between the settlement date and maturity date |
COUPPCD | Returns the previous coupon date before the settlement date |
CUMIPMT | Returns the cumulative interest paid between two periods |
CUMPRINC | Returns the cumulative principal paid on a loan between two periods |
Informational:
These functions give meta info from workbooks and compares logical values.
Title | Description |
|---|---|
CELL | Returns information about the formatting, location, or contents of a cell
This function is not available in Excel for the web. |
ERROR.TYPE | Returns a number corresponding to an error type |
INFO | Returns information about the current operating environment
This function is not available in Excel for the web. |
ISBLANK | Returns TRUE if the value is blank |
ISERR | Returns TRUE if the value is any error value except #N/A |
ISERROR | Returns TRUE if the value is any error value |
ISEVEN | Returns TRUE if the number is even |
ISFORMULA | Returns TRUE if there is a reference to a cell that contains a formula |
ISLOGICAL | Returns TRUE if the value is a logical value |
ISNA | Returns TRUE if the value is the #N/A error value |
ISNONTEXT | Returns TRUE if the value is not text |
ISNUMBER | Returns TRUE if the value is a number |
Logical:
These functions allow the use of logical operators like "If/And/Or/Xor" across a range of different criteria.
Title | Description |
|---|---|
AND | Returns TRUE if all of its arguments are TRUE |
FALSE | Returns the logical value FALSE |
IF | Specifies a logical test to perform |
IFERROR | Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula |
IFNA | Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression |
IFS | Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. |
NOT | Reverses the logic of its argument |
OR | Returns TRUE if any argument is TRUE |
SWITCH | Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. |
TRUE | Returns the logical value TRUE |
XOR | Returns a logical exclusive OR of all arguments |
Lookup and Reference:
These functions give different options to filter and return specific data.
Title | Description |
|---|---|
ADDRESS | Returns a reference as text to a single cell in a worksheet |
AREAS | Returns the number of areas in a reference |
CHOOSE | Chooses a value from a list of values |
COLUMN | Returns the column number of a reference |
COLUMNS | Returns the number of columns in a reference |
FILTER | Filters a range of data based on criteria you define |
FORMULATEXT | Returns the formula at the given reference as text |
GETPIVOTDATA | Returns data stored in a PivotTable report |
HLOOKUP | Looks in the top row of an array and returns the value of the indicated cell |
HYPERLINK | Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet |
INDEX | Uses an index to choose a value from a reference or array |
INDIRECT | Returns a reference indicated by a text value |
Math and Trigonometry:
These functions are commonly used mathematical tools, functions, and operators.
Title | Description |
|---|---|
ABS | Returns the absolute value of a number |
ACOS | Returns the arccosine of a number |
ACOSH | Returns the inverse hyperbolic cosine of a number |
ACOT | Returns the arccotangent of a number |
ACOTH | Returns the hyperbolic arccotangent of a number |
AGGREGATE | Returns an aggregate in a list or database |
ARABIC | Converts a Roman number to Arabic, as a number |
ASIN | Returns the arcsine of a number |
ASINH | Returns the inverse hyperbolic sine of a number |
ATAN | Returns the arctangent of a number |
ATAN2 | Returns the arctangent from x- and y-coordinates |
ATANH | Returns the inverse hyperbolic tangent of a number |
Statistical:
These functions provide statistical analysis tools to better understand correlations and deviations.
Title | Description |
|---|---|
AVEDEV | Returns the average of the absolute deviations of data points from their mean |
AVERAGE | Returns the average of its arguments |
AVERAGEA | Returns the average of its arguments, including numbers, text, and logical values |
AVERAGEIF | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria |
AVERAGEIFS | Returns the average (arithmetic mean) of all cells that meet multiple criteria. |
BETA.DIST | Returns the beta cumulative distribution function |
BETA.INV | Returns the inverse of the cumulative distribution function for a specified beta distribution |
BINOM.DIST | Returns the individual term binomial distribution probability |
BINOM.DIST.RANGE | Returns the probability of a trial result using a binomial distribution |
BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
CHISQ.DIST | Returns the cumulative beta probability density function |
CHISQ.DIST.RT | Returns the one-tailed probability of the chi-squared distribution |
Text:
These functions give control over any text related field, searching, converting, formatting, and editing.
Title | Description |
|---|---|
ARRAYTOTEXT | Returns an array of text values from any specified range |
ASC | Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters |
BAHTTEXT | Converts a number to text, using the ß (baht) currency format |
CHAR | Returns the character specified by the code number |
CLEAN | Removes all nonprintable characters from text |
CODE | Returns a numeric code for the first character in a text string |
CONCAT | Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. |
CONCATENATE | Joins several text items into one text item |
DBCS | Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters |
DOLLAR | Converts a number to text, using the $ (dollar) currency format |
EXACT | Checks to see if two text values are identical |
FIND | Finds one text value within another (case-sensitive) |
Web:
These functions allow the collection of data from the web using XML and XPATH.
Title | Description |
|---|---|
ENCODEURL | Returns a URL-encoded string
This function is not available in Excel for the web. |
FILTERXML | Returns specific data from the XML content by using the specified XPath
This function is not available in Excel for the web. |
WEBSERVICE | Returns data from a web service.
This function is not available in Excel for the web. |