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.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
How to Round to Nearest 5 or 10 in Google Sheets
How to Round to Significant Figures in Google Sheets
How to Find the Closest Value in Google Sheets