Microsoft Office Tutorials and References
In Depth Information
AVERAGE is one of the most widely used functions by Excel users. It is calculated by taking the
sum of the values in a data set and dividing by the number of values in the data set. Refer to
Figures 11.1 and 11.2 for examples of the AVERAGE function.
You can specify up to 30 arguments for the AVERAGE function. The
arguments can be cell references, arrays, or range names. Blank
cells or cells containing text or logical values are ignored. Cells that
contain a zero (0) are included in the Average calculation.
The AVERAGEA function calculates the average of the values in the list of arguments.
Similar to AVERAGE , the AVERAGEA function calculates the average of its arguments. The difference
is that AVERAGEA does not ignore text or logical values (TRUE and FALSE). Text and FALSE are
evaluated as zero (0) and TRUE is evaluated as one (1).
Cells that contain a zero (0), text, or logical values are included in the
AVERAGEA calculation. Arguments can be cell references, arrays, or range
names. Blank cells are ignored. You can specify up to 30 arguments for
the AVERAGEA function.
Text arguments like
“new account” evaluate
to zero and are factored
into the AVERAGEA
BETADIST returns the cumulative beta probability density function.
Is the value between A and B at which to evaluate the function, so that