Excel Functions

Syntax and Description with examples

Search now!
Generic filters
Filter by Categories
Free Excel Macro
Premium Excel Macro
Add ins
Templates
VBA Codes

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