Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inFLOOR(number, significance)
Newer FLOOR.MATH(number, [significance], [mode]) makes significance optional.
Google Sheets✔ Built inFLOOR(value, [factor])
Airtable✔ Built inFLOOR(value, [significance])
Notion≈ Workaroundfloor(number / multiple) * multiple
Notion'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 ↗
AirtableFLOOR(37, 10)
Notion
workaround
floor(37 / 10) * 10

Arguments

ArgumentWhat it means
numberThe value to round.
significanceThe multiple to round down to.

Examples

FormulaResultWhyCopy
=FLOOR(37, 10)30Group ages into decades.
=FLOOR(4.99, 0.5)4.5
=FLOOR(A2, 1/24)Start of the hourTruncate 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 −∞.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.