How to Round to Nearest 25 in Google Sheets

To round a number to the nearest 25 in Google Sheets, you can use the MROUND function. This function allows you to round a number to the nearest multiple of a specified number.

Here's how to use the MROUND function:

1. Open Google Sheets and input the number you want to round in a cell, or use a cell reference if the number is already in the sheet.
2. In an empty cell or in the cell where you want the rounded value to be displayed, type the following formula: =MROUND(number, 25), where number is the cell reference or the number you want to round.
3. Press Enter to apply the formula, and the result will be the rounded value to the nearest 25.

For example, if you want to round the number in cell A1 to the nearest 25, you would enter the formula =MROUND(A1, 25).

Example

Let's assume you have the following numbers in column A:

A
---
1. 58
2. 37
3. 80
4. 104

You want to round these numbers to the nearest 25 in column B. Here's what you would do:

1. In cell B1, type the formula =MROUND(A1, 25).
2. Press Enter, and the result in B1 will be 50, which is the nearest 25 to 58.
3. Copy the formula in B1 (Ctrl+C), and paste it (Ctrl+V) into cells B2, B3, and B4.

The final result in column B will be the rounded values to the nearest 25:

A     B
------- 
1. 58  50
2. 37  50
3. 80  75
4. 104 100