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.

BIN2DEC function Converts a binary number to the decimal number system. Engineering
BIN2HEX function Converts a binary number to hexadecimal. Engineering
BIN2OCT function Converts a binary number to octal. Engineering
BINOM.DIST function Calculates the individual term binomial distribution probability. Statistical
BINOM.INV function Statistical
BINOMDIST function Calculates the individual term binomial distribution probability Compatibility
BITAND function Calculates a bitwise 'AND' of two numbers. Engineering
BITLSHIFT function Calculates a number whose binary representation is shifted left by a specified number of bits. Engineering
BITOR function Performs a bitwise 'OR' of two numbers. Engineering
BITRSHIFT function 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 function Calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. Engineering
CEILING function Rounds a number up to its nearest multiple. Math and trigonometry
CELL function Gets information about the formatting, location, or the contents of a cell. Information
CHAR function Converts a number to the corresponding ANSI character determined by your computers character set. Text
CHIDIST function Calculates the probability of the chi-squared distribution. Compatibility
CHIINV function Calculates the inverse probability of the chi-squared distribution. Compatibility
CHISQ.DIST function Calculates the probability of the chi-squared distribution, cumulative distribution or probability density. Statistical
CHISQ.DIST.RT function Calculates the right-tailed probability of the chi-squared distribution. Statistical
CHISQ.INV function Calculates the inverse of the left-tailed probability of the chi-squared distribution. Statistical
CHISQ.INV.RT function Calculates the inverse of the right-tailed probability of the chi-squared distribution. Statistical
CHISQ.TEST function Statistical
CHITEST function Compatibility
CHOOSE function Gets a value based on a number. Lookup and reference
CLEAN function Deletes the first 32 nonprinting characters in 7-bit ASCII code in your argument. Text
CODE function Returns the corresponding number for the first character based on your computers character set. (PC- ANSI) Text
COLUMN function Returns the column number of the top-left cell of a cell reference. Lookup and reference
COLUMNS function Calculates the number of columns in a cell range. Lookup and reference
COMBIN function Returns the number of combinations for a specific number of elements out of a larger group. Math and trigonometry
COMBINA function Calculates the number of combinations for a given number of elements from a larger group of elements. Math and trigonometry
COMPLEX function Returns a complex number based on a real and imaginary number. Engineering
CONCAT function Concatenates values from multiple cells. Text

Back to top