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:
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