Rounds all numbers
in a specified range to a specified number of digits, then returns the average
(arithmetic mean) of all the rounded figures.

Syntax

AVERAGEROUND(range_input,
decimal_places)

range_input
- is the range for which you want to calculate the average.

decimal_places
- specifies the number of digits to which you want to round numbers.

Remark

Arguments that
are error values or text that cannot be translated into numbers cause errors.
See the third example below.

If decimal_places
is greater than 0 (zero), then numbers are rounded to the specified number
of decimal places.
If decimal_places
is 0, then numbers are rounded to the nearest integer.
If decimal_places
is less than 0, then numbers are rounded to the left of the decimal point.

Examples

AVERAGEROUND(A1:A2,0)
equals 6

AVERAGEROUND
(A1:A3,0) equals 6 because the text values are translated into numbers, and
the logical value TRUE is translated into the number 1.

AVERAGEROUND
(A1:A4,1) returns a #VALUE! error, because the word "Apple" in cells A4 is
text. See Also : SUMROUND PRODUCTROUND