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:

Google Sheets round to 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

Leave a Reply

Your email address will not be published.