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 |