How can I calculate the average in Google Sheets and round the result?

By /

To calculate the average in Google Sheets, first select the cells that contain the numbers you want to average. Then, type the function “=AVERAGE” into a blank cell and include the cell range in parentheses after the function. For example, if your numbers are in cells A1 to A10, the formula would be “=AVERAGE(A1:A10)”. To round the result, add the “ROUND” function around the average formula, specifying the number of decimal places you want to round to. For example, “=ROUND(AVERAGE(A1:A10), 2)” would round the average to two decimal places. Press enter and the average, rounded to the specified number of decimal places, will appear in the cell.

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:

Google Sheets round average to specific number of decimals

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:

Google Sheets round average to nearest integer

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:

x

Related terms:

  1. Google Sheets: Average Across Multiple Sheets
  2. How can I calculate the average of a group of numbers between two dates in Google Sheets?
  3. How to calculate average excluding outliers in google sheets?
  4. How do I calculate a weighted average in Google Sheets?
  5. Google Sheets: How to Calculate Average If Cell Contains Text
  6. How to Calculate Average If Not Blank in Google Sheets
  7. How to Calculate Exponential Moving Average in Google Sheets?
  8. How do you calculate the average difference in Google Sheets?
  9. How to Round to Nearest 25 in Google Sheets?
  10. How do I round to Significant Figures in Google Sheets?