Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.
Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.
Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.
AVEDEV | Statistical |
![]() |
Returns the average of the absolute deviations of data points from their mean |
AVERAGE | Statistical |
![]() |
Returns the average of its arguments |
AVERAGEA | Statistical |
![]() |
Returns the average of its arguments, including numbers, text, and logical values |
AVERAGEIF | Statistical |
![]() |
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria |
AVERAGEIFS | Statistical |
![]() |
Returns the average (arithmetic mean) of all cells that meet multiple criteria. |
BAHTTEXT | Text |
![]() |
Converts a number to text, using the ß (baht) currency format |
BASE | Math and trigonometry |
![]() |
Converts a number into a text representation with the given radix (base) |
BESSELI | Engineering |
![]() |
Returns the modified Bessel function In(x) |
BESSELJ | Engineering |
![]() |
Returns the Bessel function Jn(x) |
BESSELK | Engineering |
![]() |
Returns the modified Bessel function Kn(x) |
BESSELY | Engineering |
![]() |
Returns the Bessel function Yn(x) |
BETA.DIST | Statistical |
![]() |
Returns the beta cumulative distribution function |
BETA.INV | Statistical |
![]() |
Returns the inverse of the cumulative distribution function for a specified beta distribution |
BETADIST | Compatibility |
![]() |
Returns the beta cumulative distribution function |
BETAINV | Compatibility |
![]() |
Returns the inverse of the cumulative distribution function for a specified beta distribution |
BIN2DEC | Engineering |
![]() |
Converts a binary number to decimal |
BIN2HEX | Engineering |
![]() |
Converts a binary number to hexadecimal |
BIN2OCT | Engineering |
![]() |
Converts a binary number to octal |
BINOM.DIST | Statistical |
![]() |
Returns the individual term binomial distribution probability |
BINOM.DIST.RANGE | Statistical |
![]() |
Returns the probability of a trial result using a binomial distribution |