Table of Contents
Google Sheets is a powerful tool that allows users to perform various calculations on a set of data. One of its useful features is the ability to calculate the average of a set of numbers while also rounding the result to the nearest whole number. This can be done by using the AVERAGE and ROUND functions in Google Sheets. Simply input the numbers in a column, use the AVERAGE function to calculate the average, and then use the ROUND function to round the result to the nearest whole number. This allows for quick and accurate calculations of averages, making data analysis and decision-making easier.
Google Sheets: Calculate Average with Rounding
There are two common ways to calculate the average value of a range in Google Sheets and round the result.
Method 1: Round Average to Specific Number of Decimal Places
=ROUND(AVERAGE(A2:A14), 3)
This particular example calculates the average value of cells in the range A2:A14, then rounds the result to 3 decimal places.
Method 2: Round Average to Nearest Integer
=ROUND(AVERAGE(A2:A14), 0)
This particular example calculates the average value of cells in the range A2:A14, then rounds the result to the nearest integer.
The following examples show how to use each method in practice with the following column of values in Google Sheets, which has an average value of 20.0769:
Example 1: Round Average to Specific Number of Decimal Places
We can type the following formula into cell D2 to calculate the average of values in the range A2:A14, then round the result to 3 decimal places:
=ROUND(AVERAGE(A2:A14), 3)
The following screenshot shows how to use this formula in practice:
The formula returns the average value of the cells in the range A2:A14 rounded to 3 decimal places, which turns out to be 20.077.
Note: To round to a different number of decimal places, simply change the 3 in the ROUND function to a different number.
Example 2: Round Average to Nearest Integer
=ROUND(AVERAGE(A2:A14), 0)
The following screenshot shows how to use this formula in practice:
The formula returns the average value of the cells in the range A2:A14 rounded to the nearest integer, which turns out to be 20.
Note: If you would like to round the result up or down to the nearest integer, simply replace the ROUND function with the ROUNDUP or ROUNDDOWN functions, respectively.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets: