How to Round To Nearest 5 Using FLOOR in Google Sheets

Learn how to round to nearest 5 using the FLOOR function in Google Sheets. Step-by-step tutorial with examples.

The Formula

FLOOR(value, [factor])

Step-by-Step

1. Set up your data with headers in row 1
2. In an empty cell, type: =FLOOR(
3. Enter the required arguments for your specific use case
4. Press Enter and verify the result

Tips

Opposite of CEILING — rounds down to nearest multiple.

Get a Free Quote →