Skip to content
Google Sheets

FLOOR.PRECISE function in Google Sheets

The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. .

=FLOOR.PRECISE(number, [significance])

FLOOR.PRECISE syntax and parameters

Two arguments, one required.

  • numbernumberRequired
  • significancenumberOptional

FLOOR.PRECISE examples

Formulas you'll actually reuse.

  1. Down to the previous half, ignoring the significance's sign:

    =FLOOR.PRECISE(B2, 0.5)

    Result7.5

  2. Negatives always round toward negative infinity: −23 becomes −30:

    =FLOOR.PRECISE(-B2, 10)

    Result-30

FLOOR.PRECISE in Excel

Same name — your formula ports as-is.

Try FLOOR.PRECISE in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Google Sheets gets this done.