Skip to content
Google Sheets

FLOOR.MATH function in Google Sheets

Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.

=FLOOR.MATH(number, [significance], [mode])

FLOOR.MATH syntax and parameters

Three arguments, one required.

  • numbernumberRequired
  • significancenumberOptional
  • modenumberOptional

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 Excel

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 Google Sheets gets this done.