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:

**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:

**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:

**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