FLOOR.MATH in Excel: Round Down by Multiples and Set Negative Direction
Apply Excel FLOOR.MATH to whole-group capacity, threshold bands and negative values with a documented mode example.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: FLOOR.MATH rounds a number down to an integer or a multiple. Its default negative direction is away from zero. A mode of −1 gives a documented way to round negative values toward zero instead.
Availability and version history
- Introduced: Marked as an Excel 2013 addition in the Microsoft function catalogue; an exact first build is not established.
- Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
- Checked: October 14, 2026; official FLOOR.MATH reference. Examples are independently calculated expectations, not native Excel test results.
Syntax and optional arguments
=FLOOR.MATH(number, [significance], [mode])
Only number is required. Omitting significance uses a unit step. The examples below supply a positive significance when a larger or fractional multiple is needed. Mode changes the direction for negative values. Official FLOOR.MATH reference
Microsoft’s syntax line omits brackets, but its argument table explicitly makes significance and mode optional. Its mode prose is also less clear than its worked examples. This guide uses the demonstrated cases: omitted mode for the default, and −1 for rounding negatives toward zero. It does not extrapolate an unverified complete mode or error-code matrix.
Example 1: understand what down means
Enter 7.2, 7, −7.2, −7 in A2:A5. In B2 enter and fill down:
=FLOOR.MATH(A2)
Expected B2:B5: 7, 7, −8, −7. Down means toward a lower number, so −7.2 moves to −8. An already integral value stays at that integer.
This differs from discarding a fractional part toward zero. For a negative input, that would give −7 rather than −8. Specify your intended direction before choosing a function.
Example 2: round to six-unit multiples
=FLOOR.MATH(32.4,6)
=FLOOR.MATH(-32.4,6)
Expected results: 30 and −36. Both are multiples of six and are no greater than the original values.
For the positive number, 32.4 contains five complete groups of six, totaling 30. For the negative number, −36 is the next permitted value below −32.4. Reading down as closer to zero would produce the wrong negative result.
Example 3: use the documented negative mode
=FLOOR.MATH(-32.4,6,-1)
Expected result: −30. The mode changes the negative case to move toward zero. Compare it with −36 from the omitted-mode formula before applying the rule to a full signed dataset.
A mode flag is a policy choice; it does not alter the original data’s meaning. If negative numbers stand for returns, deficits or offsets, decide which direction is appropriate for that interpretation rather than copying a positive-only example.
Advanced example: count complete packages
Suppose fictional available quantities are 13, 24, 25, in D2:D4, and each complete kit uses six pieces. In E2 enter and fill down:
=FLOOR.MATH(D2,6)
Expected pieces allocated to complete kits: 12, 24, 24. In F2 use =E2/6; expected kit counts are 2, 4, 4. In G2 use =D2-E2; expected leftovers are 1, 0, 1.
The total kit count is 10 when these quantities are processed separately. Here pooling gives the same count: total pieces are 62, rounded down to 60, which also makes ten kits. That agreement belongs to this dataset; it is not a general identity.
For two separate quantities of 5 and 5, separate processing makes 0 kits, while a pooled quantity of 10 makes 1 complete six-piece kit. The grouping decision affects the answer.
Advanced example: assign lower band boundaries
For inputs 2, 10, 19, 20 in H2:H5, use:
=FLOOR.MATH(H2,10)
Expected lower boundaries: 0, 10, 10, 20. A value exactly at a boundary belongs to the band beginning there. This convention represents bands such as 0–less-than-10 and 10–less-than-20.
For −2, the default result is −10. The corresponding band is −10–less-than-0. Do not silently treat every negative input as belonging to the zero band if your bins use mathematical lower boundaries.
Fractional steps and precision
=FLOOR.MATH(10.6,0.25)
=FLOOR.MATH(-10.6,0.25)
=FLOOR.MATH(-10.6,0.25,-1)
Expected results: 10.5, −10.75, −10.5. The step describes quarter-unit multiples, not a decimal-place count. These ordinary inputs illustrate direction without asserting behavior for every binary floating-point boundary.
Use ROUNDDOWN when a digit count and toward-zero rounding are intended. Use INT for a simple mathematical integer floor. Keep raw values beside rounded outputs so later calculations can choose the appropriate precision.
Validate an editable step before calculating. The documented workflow here uses positive, nonzero steps; unsupported assumptions about text coercion or extreme magnitudes are outside its checked scope.
Verification: Fictional inputs and independently calculated outputs; no native Excel execution. See the editorial testing standards.