Excel Function Translator Logo
    The Excel Translator

    FLOOR.MATH

    Math & Trig

    Rounds a number down to the nearest integer or to the nearest multiple of significance, with explicit control over how negative numbers are rounded.

    Translations
    EnglishFLOOR.MATH
    FrenchPLANCHER.MATH
    SpanishMULTIPLO.INFERIOR.MAT
    GermanUNTERGRENZE.MATHEMATIK
    ItalianARROTONDA.DIFETTO.MAT
    PortugueseARREDMULTB.MAT
    DutchAFRONDEN.BENEDEN.WISK
    PolishZAOKR.W.DÓŁ.MATEMATYCZNE
    RussianОКРВНИЗ.МАТ
    TurkishTABANAYUVARLA.MAT
    CzechZAOKR.DOLŮ.MAT
    HungarianPADLÓ.MAT
    SwedishRUNDA.NER.MAT
    DanishAFRUND.GULV.MAT
    FinnishPYÖRISTÄ.KERR.ALAS.MAT
    Syntax
    FLOOR.MATH(number, [significance], [mode])

    Arguments

    • numberThe number to round down.
    • significanceOptional. The multiple to round to (default 1).(optional)
    • modeOptional. For negative numbers: 0 = round away from zero (default), nonzero = round toward zero.(optional)
    Examples
    =FLOOR.MATH(4.7)
    4

    Rounds down to nearest integer

    =FLOOR.MATH(-4.5,2)
    -6

    Negative rounded away from zero

    =FLOOR.MATH(-4.5,2,1)
    -4

    Negative rounded toward zero with mode=1

    Tips & Best Practices
    • •Available since Excel 2013 — replaces the older FLOOR with clearer behavior
    • •If significance is omitted, defaults to 1 (round to integer)
    • •Modern alternative: FLOOR.PRECISE always rounds toward -∞ regardless of sign
    Common Mistakes
    • •Assuming the mode argument works the same way in every situation - it only affects negative numbers, so testing exclusively with positive inputs can hide bugs that only show up once negative values are involved
    • •Confusing FLOOR.MATH's default rounding direction for negatives (away from zero) with FLOOR.PRECISE's fixed direction (always toward negative infinity) - the two functions can behave the same way by coincidence on some inputs but diverge depending on the mode setting
    • •Forgetting that significance and number should generally share intent even though FLOOR.MATH is more forgiving about sign mismatches than the legacy FLOOR function was
    Related Functions
    FLOOR.PRECISEAlways rounds toward negative infinity regardless of sign, removing the need for a mode argument that FLOOR.MATH requires for negative-number control.
    CEILING.MATHRounds up instead of down, using the same significance and mode argument structure as FLOOR.MATH.
    MROUNDRounds to the nearest multiple rather than always rounding down, a different rounding strategy than FLOOR.MATH's always-down behavior.
    Frequently Asked Questions

    What does the mode argument in FLOOR.MATH actually control?

    It only affects how negative numbers are rounded - 0 (the default) rounds away from zero, while any nonzero value rounds toward zero. It has no effect on positive numbers.

    What's the difference between FLOOR.MATH and FLOOR.PRECISE?

    FLOOR.PRECISE always rounds toward negative infinity regardless of sign, with no mode argument. FLOOR.MATH gives you explicit control over negative-number rounding direction via its mode argument.

    Why does FLOOR.MATH give a different result than the old FLOOR function for the same negative input?

    The legacy FLOOR function required matching signs between number and significance and had less flexible negative-number handling. FLOOR.MATH's mode argument gives explicit, more predictable control over that behavior.

    Need to translate a formula using FLOOR.MATH?

    Use our translator to convert your complete formula