## Excel Function Reference

Functions alphabetically | Functions by category

Functions are sorted from A to Z, click on a letter to quickly navigate in the table below.

Click on a link to get more detailed information about a function.

Function name | Description | Category |
---|---|---|

Converts negative numbers to positive numbers. | Math and trigonometry | |

Calculates the accrued interest for a security that pays periodic interest. | Financial | |

Calculates the accrued interest for a security that pays interest at maturity. | Financial | |

Calculates the arccosine, or inverse cosine, of a number. | Math and trigonometry | |

Calculates the inverse hyperbolic cosine of a number. | Math and trigonometry | |

ACOT functionAvailable from version: 2013 |
Calculates the inverse cotangent of a number. | Math and trigonometry |

ACOTH functionAvailable from version: 2013 |
Calculates the inverse hyperbolic cotangent of a number. | Math and trigonometry |

Returns the address of a specific cell, you need to provide a row and column number. | Lookup and reference | |

Perform different specific functions to a list or database. | Math and trigonometry | |

Perform a logical test in each argument and if all arguments return TRUE the AND function returns TRUE. | Logical | |

Returns the number of cell ranges and single cells in a reference. | Lookup and reference | |

Converts full-width (double-byte) characters to half-width (single-byte) characters. | Text | |

Calculates the arcsine of a number. | Math and trigonometry | |

Calculates the inverse hyperbolic sine of a number. | Math and trigonometry | |

Calculates the arctangent of a number. | Math and trigonometry | |

Calculates the arctangent of an angle using specific x- and y-coordinates. | Math and trigonometry | |

Calculates the inverse hyperbolic tangent of a number. | Math and trigonometry | |

Calculates the average of the absolute deviations of data points from their mean. | Statistical | |

Calculates the average of numbers in a cell range. | Statistical | |

Returns the average of a group of values. Text and boolean value FALSE evaluates to 0. TRUE to 1. | Statistical | |

AVERAGEIF functionAvailable from version: 2007 |
Returns the average of cell values that are valid for a given condition. | Statistical |

AVERAGEIFS functionAvailable from version: 2007 |
Returns the average of cell values that evaluates to TRUE for multiple criteria. | Statistical |

Converts a number into a text representation with a given radix (base). | Math and trigonometry | |

Converts a binary number to the decimal number system. | Engineering | |

Converts a binary number to hexadecimal. | Engineering | |

Converts a binary number to octal. | Engineering | |

BITAND functionAvailable from version: 2013 |
Calculates a bitwise 'AND' of two numbers. | Engineering |

BITLSHIFT functionAvailable from version: 2013 |
Calculates a number whose binary representation is shifted left by a specified number of bits. | Engineering |

BITOR functionAvailable from version: 2013 |
Performs a bitwise 'OR' of two numbers. | Engineering |

BITRSHIFT functionAvailable from version: 2013 |
Calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number. | Engineering |

BITXOR functionAvailable from version: 2013 |
Calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. | Engineering |

Rounds a number up to its nearest multiple. | Math and trigonometry | |

Gets information about the formatting, location, or the contents of a cell. | Information | |

Converts a number to the corresponding ANSI character determined by your computers character set. | Text | |

Gets a value based on a number. | Lookup and reference | |

Deletes the first 32 nonprinting characters in 7-bit ASCII code in your argument. | Text | |

Returns the corresponding number for the first character based on your computers character set. (PC- ANSI) | Text | |

Returns the column number of the top-left cell of a cell reference. | Lookup and reference | |

Calculates the number of columns in a cell range. | Lookup and reference | |

Returns the number of combinations for a specific number of elements out of a larger group. | Math and trigonometry | |

Calculates the number of combinations for a given number of elements from a larger group of elements. | Math and trigonometry | |

Returns a complex number based on a real and imaginary number. | Engineering | |

CONCAT functionAvailable from version: Office 365 |
Concatenates values from multiple cells. | Text |

Calculates the confidence interval for a population mean, using a normal distribution. | Compatibility | |

Converts a number from one measurement system to another. | Engineering | |

Calculates the correlation between two groups of numbers. | Statistical | |

Calculates the cosine of an angle. | Math and trigonometry | |

Calculates the hyperbolic cosine of a number. | Math and trigonometry | |

Calculates the cotangent of an angle specified in radians. | Math and trigonometry | |

Counts all numerical values in an argument. | Statistical | |

Counts the non-empty or blank cells in a cell range. | Statistical | |

Counts empty or blank cells in a range. | Statistical | |

Calculates the number of cells that is equal to a condition. | Statistical | |

COUNTIFS functionAvailable from version: 2007 |
Calculates the number of cells across multiple ranges that equals all given conditions. | Statistical |

Returns a number that acts as a date in the Excel environment. | Date and Time | |

Returns the number of days, months, or years between two dates. The DATEDIF function exists in order to ensure compatibility with Louts 1-2-3. | Date and Time | |

Returns an Excel date value (serial number) based on a date stored as text. | Date and Time | |

Calculates an average based on values in a list or database that meet specific conditions. | Database | |

Extracts the day as a number from an Excel date. | Date and Time | |

DAYS functionAvailable from version: 2013 |
Calculates the number of days between two dates. | Date and Time |

Counts cells containing numbers and that meet a condition or criteria. | Database | |

Counts nonempty cells in a column you specify, in a database where records also meet a condition or criteria. | Database | |

Converts a decimal number to a binary number. | Engineering | |

Converts a decimal number to a hexadecimal number. | Engineering | |

Converts a decimal number to an octal number. | Engineering | |

DECIMAL functionAvailable from version: 2013 |
Converts a text representation of a number in a given base into a decimal number. | Math and trigonometry |

Calculates degrees from radians. | Math and trigonometry | |

Fetches a value from a column in a database whose records meet a condition or criteria. | Database | |

Extracts the maximum number from a column in a database whose records match a condition or criteria. | Database | |

Extracts the smallest number from a column in a database whose records match a condition or criteria. | Database | |

Multiplies numbers that match a condition or criteria in a database. | Database | |

Calculates an estimation of the standard deviation based on a sample of a population. The function also allows you to specify criteria applied to a database. | Database | |

Calculates the standard deviation based on a population. The function also allows you to specify criteria applied to a database. | Database | |

Adds numbers in a database/list that meets a condition or criteria. | Database | |

Returns the variance of an entire population. The numbers are in a column of records in a dataset or database that meets a given condition or criteria. | Database | |

Returns a date determined by a start date and a number representing how many months. | Date and Time | |

Calculates the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. | Financial | |

ENCODEURL functionAvailable from version: 2013 |
Returns a URL-encoded string. | Web |

Returns an Excel date for the last day of a given month using a number and a start date. | Date and Time | |

Rounds a number up to the nearest even whole number. | Math and trigonometry | |

Checks if two values are precisely the same, it returns TRUE or FALSE. The EXACT function also considers upper case and lower case letters. | Text | |

Returns e raised to the power of a number, e equals 2.71828182845904. | Math and trigonometry | |

EXPON.DIST functionAvailable from version: 2010 |
Returns the exponential distribution. Use EXPON.DIST to model the time between events. | Statistical |

Returns the factorial of a number. | Math and trigonometry | |

Returns the double factorial of a number. | Math and trigonometry | |

Returns the logical (boolean) value FALSE. | Logical | |

Returns the position of a specific string in another string, reading left to right. Note, the FIND function is case-sensitive. | Text | |

Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. | Text | |

Rounds a number down, toward zero, to the nearest multiple of significance. | Compatibility | |

FLOOR.MATH functionAvailable from version: 2013 |
Rounds a number down to the nearest integer or to the nearest multiple of significance. | Math and trigonometry |

FORECAST.LINEAR functionAvailable from version: 2016 |
Calculates a value based on existing x and y values using linear regression. | Statistical |

FORMULATEXT functionAvailable from version: 2013 |
Returns a formula as a text string. | Lookup and reference |

Calculates how often values occur within a range of values and then returns a vertical array of numbers. | Statistical | |

Returns the future value of an investment based on a constant interest rate. | Financial | |

Searches the top row in a data range for a value and return another value on the same column in a row you specify. | Lookup and reference | |

Returns an integer representing the hour of an Excel time value. | Date and Time | |

Builds a link in a cell. | Lookup and reference | |

Returns one value if the logical test is TRUE and another value if the logical test is FALSE. | Logical | |

IFERROR functionAvailable from version: 2007 |
If the value argument returns an error, the value_if_error argument is used. If the value argument does NOT return an error, the IFERROR function returns the value argument. | Logical |

IFNA functionAvailable from version: 2013 |
Handles #N/A errors only, it returns a specific value if the formula returns a #N/A error. | Logical |

IFS functionAvailable from version: Office 365 |
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. | Logical |

Returns a value from a cell range, you specify which value based on a row and column number. | Lookup and reference | |

Returns the cell reference based on a text string and shows the content of that cell reference. | Lookup and reference | |

Returns information about the current operating environment, file path, number of active worksheets, Excel version etc. | Information | |

Removes the decimal part from positive numbers and returns the whole number (integer) except negative values are rounded down to the nearest integer. | Math and trigonometry | |

Returns TRUE if the argument is an empty cell, returns FALSE if not. | Information | |

Returns TRUE if a cell returns an error, except error value #N/A. | Information | |

Returns TRUE if a cell contains an error. | Information | |

ISFORMULA functionAvailable from version: 2013 |
Returns TRUE if a cell contains a formula, FALSE if text, number or boolean value. | Information |

Returns TRUE if value is boolean. A boolean value is either TRUE or FALSE. | Information | |

Returns TRUE if value is a #N/A error. | Information | |

Returns TRUE if value is not text, also returns TRUE if cell is empty. | Information | |

Checks if a value is a number, returns TRUE or FALSE. | Information | |

Returns TRUE if a cell contains an odd number, FALSE if even number. | Information | |

Calculates the interest paid during a specific period of an investment. | Financial | |

Returns TRUE if value refers to a reference. | Information | |

Returns TRUE if argument is text. | Information | |

Calculates the k-th largest value from an array of numbers. | Statistical | |

Calculates the least common multiple. The least common multiple is the smallest positive integer that is a multiple of all integer arguments. Use the LCM function to find fractions with different denominators. | Math and trigonometry | |

Extracts a specific number of characters always starting from the left. | Text | |

Returns the number of characters in a cell value. | Text | |

Calculates the natural logarithm of a number. Natural logarithms are based on the constant e. | Math and trigonometry | |

Calculates the logarithm of a number to a specific base. | Math and trigonometry | |

Find a value in a cell range and return a corresponding value on the same row. | Lookup and reference | |

Converts a value to lower case letters. | Text | |

Returns the relative position of an item in an array that matches a specified value in a specific order. | Lookup and reference | |

Calculate the largest number in a cell range. | Statistical | |

MAXIFS functionAvailable from version: 2016 |
Calculates the highest value based on a condition or criteria. | Statistical |

Calculates the median based on a group of numbers. The median is the middle number of a group of numbers. | Statistical | |

Returns a substring from a string based on the starting position and the number of characters you want to extract. | Text | |

Returns the smallest number in a cell range. | Statistical | |

Returns the smallest number. Text values and blanks are ignored, boolean value TRUE evaluates to 1 and FALSE to 0 (zero). | Statistical | |

MINIFS functionAvailable from version: 2016 |
Calculates the smallest value based on a given set of criteria. | Statistical |

Returns a whole number representing the minute based on an Excel time value. The returned number is ranging from 0 to 59. | Date and Time | |

Calculates the inverse matrix for a given array. | Math and trigonometry | |

Calculates the matrix product of two arrays, an array as the same number of rows as array1 and columns as array2. | Math and trigonometry | |

Returns the remainder after a number is divided by divisor. | Math and trigonometry | |

Calculates the most frequent number in a cell range. | Compatibility | |

MODEMULT functionAvailable from version: 2010 |
Returns the most frequent number in a cell range. It will return multiple numbers if they are equally frequent. | Statistical |

Extracts the month as a number from an Excel date. | Date and Time | |

Calculates a number rounded to a given multiple. | Math and trigonometry | |

Calculates the ratio of the factorial of a sum of values to the product of factorials. | Math and trigonometry | |

MUNIT functionAvailable from version: 2013 |
Calculates the identity matrix for a given dimension | Math and trigonometry |

Returns a value converted into a number. | Information | |

Returns the error value #N/A meaning "value is not available". | Information | |

Returns the number of working days between two dates, excluding weekends. It also allows you to ignore a list of holiday dates that you can specify. | Date and Time | |

Calculates the nominal annual interest rate based on the effective rate and the number of compounding periods per year. | Financial | |

NORM.DIST functionAvailable from version: 2010 |
Calculates the normal distribution for a given mean and standard deviation. | Statistical |

NORM.INV functionAvailable from version: 2010 |
Calculates the inverse of the normal cumulative distribution for a given mean and standard deviation. | Statistical |

Returns the boolean opposite to the given argument. | Logical | |

Returns the current date and time. | Date and Time | |

Returns a reference to a range that is a given number of rows and columns from a given reference. | Lookup and reference | |

Evaluates a logical expression in each argument and if at least one argument returns TRUE the OR function returns TRUE. If all arguments return FALSE the OR function also returns FALSE. | Logical | |

Returns the number of permutations for a set of elements that can be selected from a larger number of elements. | Statistical | |

Returns the number of permutations for a specific number of elements that can be selected from a larger group of elements. | Statistical | |

Returns the number pi (¶). | Math and trigonometry | |

Calculates a number raised to a power. | Math and trigonometry | |

Returns the product of the numbers given in the argument. | Math and trigonometry | |

QUARTILE.INC functionAvailable from version: 2010 |
Returns the quartile of a data set, based on percentile values from 0..1, inclusive. | Statistical |

Returns the integer portion of a division. | Math and trigonometry | |

Converts degrees to radians. | Math and trigonometry | |

Calculates a random real number greater than or equal to 0 and less than 1. | Math and trigonometry | |

Returns a random whole number between the numbers you specify. | Math and trigonometry | |

Calculates the rank of a specific number compared to a list of numbers. | Compatibility | |

RANK.AVG functionAvailable from version: 2010 |
Returns the rank of a number out of a list of numbers. | Statistical |

Returns the interest rate per period of an annuity. | Financial | |

Repeats a specific text a chosen number of times. | Text | |

Extracts a specific number of characters always starting from the right. | Text | |

Calculates the row number of a cell reference. | Lookup and reference | |

Calculate the number of rows in a cell range. | Lookup and reference | |

Returns the number of the character at which a specific character or text string is found reading left to right (not case-sensitive) | Text | |

Calculates the secant of an angle. | Math and trigonometry | |

Calculates the hyperbolic secant of an angle. | Math and trigonometry | |

Returns an integer representing the second based on an Excel time value | Date and Time | |

Calculates the sum of a power series based on a formula. | Math and trigonometry | |

Returns the sheet number of the cell reference sheet. | Information | |

Returns the number of sheets in a reference. | Information | |

Returns the sign of a number. 1 for a positiv number, 0 (zero) for a 0 (zero) and -1 for a negative number. | Math and trigonometry | |

Calculates the sine of an angle. | Math and trigonometry | |

Calculates the hyperbolic sine of a number. | Math and trigonometry | |

Returns the k-th smallest value from a group of numbers. | Statistical | |

Calculates the positive square root. | Math and trigonometry | |

Calculates a normalized value from a distribution characterized by mean and standard_dev. | Statistical | |

Calculates the standard deviation of a group of values. | Compatibility | |

STDEV.P functionAvailable from version: 2010 |
Returns standard deviation based on the entire population. | Statistical |

STDEV.S functionAvailable from version: 2010 |
Returns standard deviation based on a sample of the entire population. | Statistical |

Estimates the standard deviation from a sample of values. | Statistical | |

Returns the standard deviation based on the entire population, including text and logical values. | Statistical | |

Replaces a specific text string in a value. Case sensitive. | Text | |

Returns a subtotal from a list or database, you can choose from a variety of arguments that determine what you want the function to do. | Math and trigonometry | |

Allows you to add numerical values, the function returns the sum in the cell it is entered in. The SUM function is cleverly designed to ignore text and boolean values, adding only numbers. | Math and trigonometry | |

Sums numerical values based on a condition. | Math and trigonometry | |

SUMIFS functionAvailable from version: 2007 |
Adds numbers based on criteria. | Math and trigonometry |

Calculates the product of corresponding values and then returns the sum of each multiplication. | Math and trigonometry | |

Calculates the sum of the squares of the arguments. | Math and trigonometry | |

Calculates the sum of the difference of squares of corresponding values in two arrays. | Math and trigonometry | |

Calculates the sum of the sum of squares of corresponding values in two arrays. | Math and trigonometry | |

Calculates the sum of squares of differences of corresponding values in two arrays. | Math and trigonometry | |

SWITCH functionAvailable from version: 2016 |
Returns a given value determined by an expression and a list of values. | Logical |

Returns a text value if the argument is a text value. | Text | |

Calculates the tangent of an angle. | Math and trigonometry | |

Calculates the hyperbolic tangent of a number. | Math and trigonometry | |

Converts a value to text in a specific number format. | Text | |

TEXTJOIN functionAvailable from version: Office 365 |
Combine text strings from multiple cell ranges. | Text |

Returns a decimal value between 0 (zero) representing 12:00:00 AM and 0.99988426 representing 11:59:59 P.M. | Date and Time | |

Returns a decimal number based on a text string. | Date and Time | |

Returns the Excel date (serial number) of the current date. | Date and Time | |

Converts a vertical range to a horizontal range, or vice versa. | Lookup and reference | |

Calculates values along a linear trend. | Statistical | |

Deletes all blanks or space characters except single blanks between words in a cell value. | Text | |

Calculates the mean of the interior of a data set. | Statistical | |

Returns the logical (boolean) value TRUE. | Logical | |

Removes the fractional part of the number to an integer. | Math and trigonometry | |

Use TYPE to find out what type of data is returned by a function or formula. | Information | |

Converts a value to upper case letters. | Text | |

Converts a text string that represents a number to a number. | Text | |

VAR.P functionAvailable from version: 2010 |
Returns the variance based on the entire population. The function ignores logical and text values. | Statistical |

VAR.S functionAvailable from version: 2010 |
The VAR.S function tries to estimate the variance based on a sample of the population. The function ignores logical and text values. | Statistical |

Lets you search the leftmost column for a value and return another value on the same row in a column you specify. | Lookup and reference | |

WEBSERVICE functionAvailable from version: 2013 |
Gets data from a web service on the Internet or Intranet. | Web |

Converts a date to a weekday number from 1 to 7. | Date and Time | |

Converts a date to a number representing the year in the date. | Date and Time |