How to Round Up or Down to Nearest 5 or 10 in Google Sheets


You can use the following formulas to round values to the nearest 5 or 10 in Google Sheets:

Method 1: Round to Nearest 5

#round value in cell A1 to nearest 5
=MROUND(A1, 5)

#round value in cell A1 up to nearest 5
=CEILING(A1, 5)

#round value in cell A1 down to nearest 5
=FLOOR(A1, 5)

Method 2: Round to Nearest 10

#round value in cell A1 to nearest 10
=MROUND(A1, 10)

#round value in cell A1 up to nearest 10
=CEILING(A1, 10)

#round value in cell A1 down to nearest 10
=FLOOR(A1, 10)

The following examples show how to use each formula in practice.

Example 1: Rounding to Nearest 5 in Google Sheets

The following screenshot shows how to round each value in column A to the nearest 5:

Google Sheets round to nearest 5

The formulas in column B round the values to the nearest 5.

The formulas in column C round the values up to the nearest 5.

And the formulas in column D round the values down to the nearest 5.

Example 2: Rounding to Nearest 10 in Google Sheets

The following screenshot shows how to round each value in column A to the nearest 10:

The formulas in column B round the values to the nearest 10.

The formulas in column C round the values up to the nearest 10.

And the formulas in column D round the values down to the nearest 10.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Round to Significant Figures in Google Sheets
How to Find the Closest Value in Google Sheets
How to Extract Numbers from String in Google Sheets

Leave a Reply

Your email address will not be published.