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 |