Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

AVERAGE(number1,number2, ...) [Category: Statistical]]

Returns the average (arithmetic mean) of the arguments. Guru Tip: One of the

top ﬁ ve functions, right up there with SUM. Annoyingly, the
AVERAGE
of a range

of blank cells returns a division by zero error.

AVERAGEA(value1,value2,...) [Category: Statistical]]

Calculates the average (arithmetic mean) of the values in the list of arguments.

In addition to numbers, text and logical values such as TRUE and FALSE are

included in the calculation.

AVERAGEIF(range,criteria,average_range) [Category: Statistical]]

Returns the average (arithmetic mean) of all the cells in a range that meet a

criteria. New in Excel 2007. Guru Tip: Microsoft added this function in Excel

2007, apparently for people who were tired of using SUMIF()/COUNTIF.

AVERAGEIFS(average_range,criteria_range1,criteria1,[criteria_

range2,criteria2,…]) [Category: Statistical]]

Returns the average (arithmetic mean) of all the cells that meet multiple criteria.

New in Excel 2007. Guru Tip: One of three "plural" functions added in Excel

2007, designed to increase the number of criteria in SUMIF and COUNTIF from

1 to 127.

BAHTTEXT(number) [Category: Text]

New in Excel XP: Converts a number to Thai text and adds a sufﬁ x of "Baht".

BESSELI(x,n) [Category: Engineering]*

Returns the modiﬁ ed Bessel function, which is equivalent to the Bessel function

evaluated for purely imaginary arguments. Guru Tip: The BESSEL functions

are useful in physics when solving partial differential equations in cylindrical

coordinates. It is also useful for getting a laugh in front of a room full of

accountants; "the ﬁ rst question ever sent in to MrExcel.com asked me to explain

how to use the BESSELJ function".

BESSELJ(x,n) [Category: Engineering]*

Returns the Bessel function.

BESSELK(x,n) [Category: Engineering]*

Returns the modiﬁ ed Bessel function, which is equivalent to the Bessel functions

evaluated for purely imaginary arguments.

BESSELY(x,n) [Category: Engineering]*

Returns the Bessel function, which is also called the Weber function or the

Neumann function.

BETADIST(x,alpha,beta,A,B) [Category: Statistical]]

Returns the cumulative beta probability density function. The cumulative beta

probability density function is commonly used to study variation in the percentage