Programming Excel with VBA and .NET

The WorksheetFunction Object

Another useful top-level object to know about is the WorksheetFunction object. That object provides the functions from the Excel formula bar to your Visual Basic code. Some of these members are redundant with those provided by the VBA object library, however, others provide very useful (and advanced) analytical and statistical functions, as described in Table 4-8.

Table 4-8. Members of the WorksheetFunction object

Member	Description
Acos	Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is a number. The returned angle is given in radians in the range 0 to π.
Acosh	Returns the inverse hyperbolic cosine of a number.
And	The same as the Visual Basic And operator.
Asc	Converts double-byte characters to single-byte characters.
Asin	Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is the given number. The returned angle is given in radians in the range −π/2 to π/2.
Asinh	Returns the inverse hyperbolic sine of a number.
Atan2	Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates.
Atanh	Returns the inverse hyperbolic tangent of a number.
AveDev	Returns the average of the absolute deviations of data points from their mean. AveDev is a measure of the variability in a data set.
Average	Returns the average (arithmetic mean) of the arguments.
BetaDist	Returns the beta cumulative distribution function.
BetaInv ...