Knowledge base / Excel
FLOOR in Excel: multiples, signs and rounding variants
Distinguish FLOOR from ROUNDDOWN, understand the increment sign and compare negative results from FLOOR.MATH and FLOOR.PRECISE.

FLOOR rounds to a multiple of a specified increment. Its second argument is different from ROUNDDOWN’s digit count. I first write down the unit and the increment, because similar function names can hide calculations with very different meanings.
The basic examples use a positive increment and small synthetic values. Negative numbers and the differences between FLOOR, FLOOR.MATH and FLOOR.PRECISE are covered separately. That is where down is most easily confused with towards zero.
Syntax and a first result
Microsoft’s documentation gives:
=FLOOR(number,significance)
Significance is the increment whose multiple the output must be. For 23 with an increment of 5, the adjacent multiples are 20 and 25. Rounding down selects 20. A value already on the increment, such as 25, remains unchanged.
Polish Excel calls the function ZAOKR.W.DÓŁ. These examples use English names, commas between arguments and decimal points. Actual separators depend on regional settings. When copying a formula, make sure the notation matches your installation and contains no explanatory comments appended to the expression.
Multiples and decimal places are different
| Formula | Result | Meaning |
|---|---|---|
=FLOOR(23,5) |
20 | Whole multiples of five |
=FLOOR(14.7,0.5) |
14.5 | A half-unit increment |
=FLOOR(7.89,1) |
7 | A one-unit increment |
=ROUNDDOWN(7.89,1) |
7.8 | One decimal place |
The final row uses ROUNDDOWN, a different function. If the requirement is one digit after the decimal point, an increment of 1 in FLOOR does not implement it. Label the parameter so another reader can distinguish a unit increment from a precision setting.
When changing the increment, check a value exactly on its boundary as well. At an increment of 5, inputs 24 and 25 produce 20 and 25. That small comparison explains the rule more clearly than checking one arbitrary value far from a boundary.
Full groups and the remainder
Suppose there are 17 synthetic items arranged in groups of 5. =FLOOR(17,5) returns 15 items fitting into complete groups. It does not return 15 groups. There are three full groups in this example, with two items left outside them.
If you need enough packages to hold every item, you need a different rounding direction. See the example in ROUNDUP. Both tasks involve packages, but they answer different questions and should not share a formula merely because their source columns look similar.

Negative numbers and the sign of the increment
With positive significance 4, =FLOOR(-17,4) returns -20. On a number line, -20 lies below -17. The result moves away from zero, so describing FLOOR as always rounding towards zero is incorrect.
The classic function also responds to the increment’s sign. Microsoft’s example =FLOOR(-2.5,-2) returns -2. A positive input with negative significance, such as =FLOOR(2.5,-2), returns #NUM!. Do not extend a description written for positive increments to every combination of argument signs.
For an ordinary schedule or grouping exercise, I keep the increment positive and label its unit. If negative values require deliberate direction control, I consider the mathematical variant. An explicit mode is easier to explain than a rule hidden in the sign of the increment entered in a parameter cell.
FLOOR.MATH and FLOOR.PRECISE
FLOOR.MATH provides an optional mode controlling negative values. With its default mode, -17 and significance 4 give -20. A nonzero mode changes the negative rounding direction towards zero, allowing a result of -16.
=FLOOR.MATH(-17,4)
=FLOOR.MATH(-17,4,1)
The first returns -20, the second -16. FLOOR.PRECISE with -17 and significance 4 returns -20, not -16. It uses the absolute increment and rounds mathematically down. Similar names alone do not establish identical behavior across a family of functions.
Resolve input meaning before hiding errors
The exercises use a positive, nonzero increment. If a source contains zero, a missing value or text, establish what that record represents first. Do not assign one zero-significance result to the entire family: variants have their own rules, and FLOOR.PRECISE documentation specifically describes returning zero in that situation.
Rounding down also does not automatically produce a cautious estimate. Reducing forecast income and reducing forecast costs can support very different decisions. The function performs a mathematical operation; the report’s purpose determines whether that direction is appropriate. State the policy rather than treating the function name as its justification.
An exercise: function, increment and unit
At significance 5, follow inputs 19, 20 and 21. Expected results are 15, 20 and 20. With positive significance 4, compare -17 and -16: results are -20 and -16. Mark where zero lies and explain which way the value moves before writing a description of the result.
In your own table, name the parameter, for example items per complete group. That helps distinguish an output measured in items from a group count or a decimal-place setting. Keep that explanation even when the calculation itself fits comfortably into one line.
Key takeaways
How does FLOOR differ from ROUNDDOWN?
FLOOR takes a multiple as its second argument. ROUNDDOWN takes a number of decimal places and rounds towards zero.
What does FLOOR return for -17 with positive significance 4?
-20, the lower multiple of four, which lies further from zero.
How can FLOOR.MATH return -16 instead of -20?
For -17 with significance 4, provide a nonzero third mode argument such as 1. This switches negative rounding towards zero.
AI was used in an automated way while working on this article. If you want to learn how to do it too, check out this project.
