Skip to content
ExcelExcel 2013+

FLOOR.MATH function in Excel

Rounds a number down, to the nearest integer or to the nearest multiple of significance

=FLOOR.MATH(number, significance, mode)

FLOOR.MATH syntax and parameters

Three arguments, one required.

  • numbernumberRequired

    The number to be rounded down.

  • significancenumberOptional

    The multiple to which you want to round.

  • modenumberOptional

    The direction (toward or away from 0) to round negative numbers.

FLOOR.MATH examples

Formulas you'll actually reuse.

  1. Billable hours rounded DOWN to the half hour:

    =FLOOR.MATH(B2, 0.5)

    Result7.5

  2. Negatives toward zero with mode 1 — −23 becomes −20:

    =FLOOR.MATH(-B2, 10, 1)

    Result-20

FLOOR.MATH in Google Sheets

Same name — your formula ports as-is.

Try FLOOR.MATH in the playground

Edit the example — nothing to install.

Preloaded with the FLOOR.MATH formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.