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

ArgumentRequired?What it does
numberYesThe value to round.
significanceOptionalThe multiple to round down to. Default 1.
modeOptionalFor 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)
AB
1AgeBand
23430
34040
45850
=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

Kyle Stott

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.