## 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 | Version | Function category |
---|---|---|

ABS functionConverts negative numbers to positive numbers. |
Math and trigonometry | |

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

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

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

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

ACOT functionCalculates the inverse cotangent of a number. |
2013 | Math and trigonometry |

ACOTH functionCalculates the inverse hyperbolic cotangent of a number. |
2013 | Math and trigonometry |

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

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

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

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

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

ASIN functionCalculates the arcsine of a number. |
Math and trigonometry | |

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

ATAN functionCalculates the arctangent of a number. |
Math and trigonometry | |

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

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

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

AVERAGE functionCalculates the average of numbers in a cell range. |
Statistical | |

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

AVERAGEIF functionReturns the average of cell values that are valid for a given condition. |
2007 | Statistical |

AVERAGEIFS functionReturns the average of cell values that evaluates to TRUE for multiple criteria. |
2007 | Statistical |

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

BIN2DEC functionConverts a binary number to the decimal number system. |
Engineering | |

BIN2HEX functionConverts a binary number to hexadecimal. |
Engineering | |

BIN2OCT functionConverts a binary number to octal. |
Engineering | |

BITAND functionCalculates a bitwise 'AND' of two numbers. |
2013 | Engineering |

BITLSHIFT functionCalculates a number whose binary representation is shifted left by a specified number of bits. |
2013 | Engineering |

BITOR functionPerforms a bitwise 'OR' of two numbers. |
2013 | Engineering |

BITRSHIFT functionCalculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number. |
2013 | Engineering |

BITXOR functionCalculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. |
2013 | Engineering |

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

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

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

CHOOSE functionGets a value based on a number. |
Lookup and reference | |

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

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

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

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

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

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

COMPLEX functionReturns a complex number based on a real and imaginary number. |
Engineering | |

CONCAT functionConcatenates values from multiple cells. |
2016 | Text |

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

CONVERT functionConverts a number from one measurement system to another. |
Engineering | |

CORREL functionCalculates the correlation between two groups of numbers. |
Statistical | |

COS functionCalculates the cosine of an angle. |
Math and trigonometry | |

COSH functionCalculates the hyperbolic cosine of a number. |
Math and trigonometry | |

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

COUNT functionCounts all numerical values in an argument. |
Statistical | |

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

COUNTBLANK functionCounts empty or blank cells in a range. |
Statistical | |

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

COUNTIFS functionCalculates the number of cells across multiple ranges that equals all given conditions. |
2007 | Statistical |

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

DATEDIF functionReturns 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 | |

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

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

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

DAYS functionCalculates the number of days between two dates. |
2013 | Date and Time |

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

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

DEC2BIN functionConverts a decimal number to a binary number. |
Engineering | |

DEC2HEX functionConverts a decimal number to a hexadecimal number. |
Engineering | |

DEC2OCT functionConverts a decimal number to an octal number. |
Engineering | |

DECIMAL functionConverts a text representation of a number in a given base into a decimal number. |
2013 | Math and trigonometry |

DEGREES functionCalculates degrees from radians. |
Math and trigonometry | |

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

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

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

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

DSTDEV functionCalculates 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 | |

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

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

DVARP functionReturns 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 | |

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

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

ENCODEURL functionReturns a URL-encoded string. |
2013 | Web |

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

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

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

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

EXPON.DIST functionReturns the exponential distribution. Use EXPON.DIST to model the time between events. |
2010 | Statistical |

FACT functionReturns the factorial of a number. |
Math and trigonometry | |

FACTDOUBLE functionReturns the double factorial of a number. |
Math and trigonometry | |

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

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

FIXED functionRounds 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 | |

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

FLOOR.MATH functionRounds a number down to the nearest integer or to the nearest multiple of significance. |
2013 | Math and trigonometry |

FORECAST.LINEAR functionCalculates a value based on existing x and y values using linear regression. |
2016 | Statistical |

FORMULATEXT functionReturns a formula as a text string. |
2013 | Lookup and reference |

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

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

HLOOKUP functionSearches 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 | |

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

HYPERLINK functionBuilds a link in a cell. |
Lookup and reference | |

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

IFERROR functionIf 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. |
2007 | Logical |

IFNA functionHandles #N/A errors only, it returns a specific value if the formula returns a #N/A error. |
2013 | Logical |

IFS functionChecks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. |
2016 | Logical |

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

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

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

INT functionRemoves 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 | |

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

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

ISERROR functionReturns TRUE if a cell contains an error. |
Information | |

ISFORMULA functionReturns TRUE if a cell contains a formula, FALSE if text, number or boolean value. |
2013 | Information |

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

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

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

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

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

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

ISREF functionReturns TRUE if value refers to a reference. |
Information | |

ISTEXT functionReturns TRUE if argument is text. |
Information | |

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

LCM functionCalculates 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 | |

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

LEN functionReturns the number of characters in a cell value. |
Text | |

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

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

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

LOWER functionConverts a value to lower case letters. |
Text | |

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

MAX functionCalculate the largest number in a cell range. |
Statistical | |

MAXIFS functionCalculates the highest value based on a condition or criteria. |
2016 | Statistical |

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

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

MIN functionReturns the smallest number in a cell range. |
Statistical | |

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

MINIFS functionCalculates the smallest value based on a given set of criteria. |
2016 | Statistical |

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

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

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

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

MODE functionCalculates the most frequent number in a cell range. |
Compatibility | |

MODEMULT functionReturns the most frequent number in a cell range. It will return multiple numbers if they are equally frequent. |
2010 | Statistical |

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

MROUND functionCalculates a number rounded to a given multiple. |
Math and trigonometry | |

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

MUNIT functionCalculates the identity matrix for a given dimension |
2013 | Math and trigonometry |

N functionReturns a value converted into a number. |
Information | |

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

NETWORKDAYS functionReturns 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 | |

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

NORM.DIST functionCalculates the normal distribution for a given mean and standard deviation. |
2010 | Statistical |

NORM.INV functionCalculates the inverse of the normal cumulative distribution for a given mean and standard deviation. |
2010 | Statistical |

NOT functionReturns the boolean opposite to the given argument. |
Logical | |

NOW functionReturns the current date and time. |
Date and Time | |

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

OR functionEvaluates 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 | |

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

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

PI functionReturns the number pi (¶). |
Math and trigonometry | |

POWER functionCalculates a number raised to a power. |
Math and trigonometry | |

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

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

QUOTIENT functionReturns the integer portion of a division. |
Math and trigonometry | |

RADIANS functionConverts degrees to radians. |
Math and trigonometry | |

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

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

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

RANK.AVG functionReturns the rank of a number out of a list of numbers. |
2010 | Statistical |

RATE functionReturns the interest rate per period of an annuity. |
Financial | |

REPT functionRepeats a specific text a chosen number of times. |
Text | |

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

ROW functionCalculates the row number of a cell reference. |
Lookup and reference | |

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

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

SEC functionCalculates the secant of an angle. |
Math and trigonometry | |

SECH functionCalculates the hyperbolic secant of an angle. |
Math and trigonometry | |

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

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

SHEET functionReturns the sheet number of the cell reference sheet. |
Information | |

SHEETS functionReturns the number of sheets in a reference. |
Information | |

SIGN functionReturns 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 | |

SIN functionCalculates the sine of an angle. |
Math and trigonometry | |

SINH functionCalculates the hyperbolic sine of a number. |
Math and trigonometry | |

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

SQRT functionCalculates the positive square root. |
Math and trigonometry | |

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

Compatibility | ||

2010 | Statistical | |

2010 | Statistical | |

Statistical | ||

Statistical | ||

Text | ||

Math and trigonometry | ||

Math and trigonometry | ||

Math and trigonometry | ||

2007 | Math and trigonometry | |

Math and trigonometry | ||

Math and trigonometry | ||

Math and trigonometry | ||

Math and trigonometry | ||

Math and trigonometry | ||

2016 | Logical | |

Text | ||

Math and trigonometry | ||

Math and trigonometry | ||

Text | ||

2016 | Text | |

Date and Time | ||

Date and Time | ||

Date and Time | ||

Lookup and reference | ||

Statistical | ||

Text | ||

Statistical | ||

Logical | ||

Math and trigonometry | ||

Information | ||

Text | ||

Text | ||

VAR.P functionReturns the variance based on the entire population. The function ignores logical and text values. |
2010 | Statistical |

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

Lookup and reference | ||

WEBSERVICE functionGets data from a web service on the Internet or Intranet. |
2013 | Web |

Date and Time | ||

Date and Time |