FLOOR.MATH Function
Rounds a number down to the nearest integer or multiple.
Category
Math & Trig
Available in
Excel 2013+, Microsoft 365
Returns
A number
Want to practice FLOOR.MATH in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
FLOOR.MATH rounds down to a multiple you choose — or to the whole number below if you leave significance out.
For negative numbers it rounds away from zero by default (−4.3 → −5); set mode to 1 to round towards zero.
Syntax
=FLOOR.MATH(number, [significance], [mode])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to round. |
| significance | Optional | The multiple to round down to. Default 1. |
| mode | Optional | For negative numbers: 0 (default) rounds away from zero, any other value towards zero. |
Examples
Example 1 — Age bands
Group customers into 10-year age bands.
B2fx=FLOOR.MATH(A2, 10)
| A | B | |
|---|---|---|
| 1 | Age | Band |
| 2 | 34 | 30 |
| 3 | 40 | 40 |
| 4 | 58 | 50 |
=FLOOR.MATH(A2, 10) Explain
=FLOOR.MATH(A2,10)&"–"&FLOOR.MATH(A2,10)+9 labels the band as 30–39.
Common mistakes
- Negatives go down. FLOOR.MATH(−4.3) is −5. Use mode 1 or TRUNC if you want −4.
Notes
- Related functions: CEILING.MATH, FLOOR.PRECISE, INT, ROUNDDOWN.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.