FLOOR Function in Excel, Google Sheets, Airtable & Notion
FLOOR rounds a number down to the nearest multiple of a significance, such as down to the nearest 10 to group values into bands.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | FLOOR(number, significance)Newer FLOOR.MATH(number, [significance], [mode]) makes significance optional. |
| Google Sheets | ✔ Built in | FLOOR(value, [factor]) |
| Airtable | ✔ Built in | FLOOR(value, [significance]) |
| Notion | ≈ Workaround | floor(number / multiple) * multipleNotion's floor() only rounds to whole numbers, so divide by the multiple first. |
Try FLOOR with your own values
Result (as Excel & Google Sheets return it)
30
Your formula, ready to paste
| Excel | =FLOOR(37, 10) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =FLOOR(37, 10) | open sheets.new ↗ |
| Airtable | FLOOR(37, 10) | |
| Notion workaround | floor(37 / 10) * 10 |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
number | The value to round. |
significance | The multiple to round down to. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=FLOOR(37, 10) | 30 | Group ages into decades. | |
=FLOOR(4.99, 0.5) | 4.5 | ||
=FLOOR(A2, 1/24) | Start of the hour | Truncate a time to the hour. | |
=FLOOR(A2, 10)&"–"&FLOOR(A2, 10)+9 | "30–39" | Build a band label. |
Examples use Excel / Google Sheets syntax unless noted.
How FLOOR works
FLOOR is the natural way to put values into equal-width buckets: ages into decades, order values into $50 bands, timestamps into hourly slots. Pair it with a pivot table or COUNTIF to build a quick histogram.
With negative numbers and a positive significance, Excel rounds away from zero (FLOOR(−2.5, 2) is −4), i.e. toward −∞, which is consistent with bucketing. In Notion, divide by the step, use floor() and multiply back.
Frequently Asked Questions
- What is the difference between FLOOR and ROUNDDOWN?
- ROUNDDOWN works in decimal places and rounds toward zero. FLOOR works with any multiple and rounds toward −∞.