How to Round Numbers to the Nearest 5 in Google Sheets


Often you may want to round values to the nearest 5 in Google Sheets.

You can use the following functions to do so:

  • MROUND(value, 5) – Round to the nearest 5.
  • CEILING(value, 5) – Round up to the nearest 5.
  • FLOOR(value, 5) – Round down to the nearest 5.

This tutorial provides an example of how to use each of these functions in practice.

Example 1: Round to the Nearest 5

The following screenshot shows how to round values to the nearest 5 by using the MROUND() function:

Round to the nearest 5 in Google Sheets

Example 2: Round Up to the Nearest 5

The following screenshot shows how to round values up to the nearest 5 by using the CEILING() function:

Round up to nearest 5 in Google Sheets

Example 3: Round Down to the Nearest 5

The following screenshot shows how to round values down to the nearest 5 by using the FLOOR() function:

Round down to nearest 5 in Google Sheets

Additional Resources

How to Calculate a Five Number Summary in Google Sheets
How to Calculate Z-Scores in Google Sheets
How to Round to Significant Figures in Google Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *