How to Round to Nearest 5 or 10 in Google Sheets

To round to the nearest 5 or 10 in Google Sheets, you can use the MROUND function. Below are the instructions to do so:

1. Open your Google Sheet.
2. Click on an empty cell where you want the rounded value to appear.
3. Enter the following formula to round to the nearest 5:

   =MROUND(A1, 5)

   Replace A1 with the cell reference containing the number you want to round. If you want to round to the nearest 10, change the 5 to 10.
4. Press Enter to apply the formula. The rounded value will appear in the selected cell.

Example

Let's say you have the following values in column A:

A
---
1. 23
2. 47
3. 89
4. 12
5. 34

Now, you want to round these values to the nearest 5 in column B. You can use the MROUND function as follows:

B
---
1. =MROUND(A1, 5)
2. =MROUND(A2, 5)
3. =MROUND(A3, 5)
4. =MROUND(A4, 5)
5. =MROUND(A5, 5)

The resulting values in column B will be:

B
---
1. 25
2. 45
3. 90
4. 10
5. 35

For rounding to the nearest 10, simply change the 5 to 10 in the formula:

B
---
1. =MROUND(A1, 10)
2. =MROUND(A2, 10)
3. =MROUND(A3, 10)
4. =MROUND(A4, 10)
5. =MROUND(A5, 10)

The resulting values in column B will be:

B
---
1. 20
2. 50
3. 90
4. 10
5. 30