AVERAGEROUND

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