# Excel Functions

Syntax and Description with examples

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Filter by Categories

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