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

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

Replace`=MROUND(A1, 5)`

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

. - 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
```

Did you find this useful?