Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
FLOOR
FLOOR always rounds a number down (toward zero) to the nearest multiple of the significance you specify. It is the complement of CEILING and is useful for truncating values to the nearest bin, such as rounding down minutes to the nearest 5-minute interval.
Excel
=FLOOR(A2,5)Google Sheets
=FLOOR(A2,5)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Minutes | Floored |
| 23 | |
| 29 | |
| 7 | |
| 45 |
=FLOOR(A2,5)→20
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 contains the number to round down (e.g. 23 minutes).
- 25 is the significance — the result will be the largest multiple of 5 that does not exceed A2.
- 3FLOOR always rounds toward zero, so 23 becomes 20 and 29 becomes 25.