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 A1upto nearest 5 =CEILING(A1, 5) #round value in cell A1downto 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 A1upto nearest 10 =CEILING(A1, 10) #round value in cell A1downto 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:

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