## 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