# How to Round to Nearest 25 in Google Sheets

You can use the following formulas to round values to the nearest 25 in Google Sheets:

Formula 1: Round to Nearest 25

```=MROUND(A1, 25)
```

Formula 2: Round Up to Nearest 25

```=CEILING(A1, 25)
```

Formula 3: Round Down to Nearest 25

`=FLOOR(A1, 25)`

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

### Example 1: Round to Nearest 25

The following screenshot shows how to use the MROUND function to round each value in column A to the nearest 25: The values in column B represent the values in column A rounded to the nearest 25.

### Example 2: Round Up to Nearest 25

The following screenshot shows how to use the CEILING function to round each value in column A up to the nearest 25: The values in column B represent the values in column A rounded up to the nearest 25.

### Example 3: Round Down to Nearest 25

The following screenshot shows how to use the FLOOR function to round each value in column A down to the nearest 25: The values in column B represent the values in column A rounded down to the nearest 25.