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.