Skip to content
Excel

FLOOR.PRECISE function in Excel

Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.

=FLOOR.PRECISE(number, [significance])

FLOOR.PRECISE syntax and parameters

Two arguments, one required.

  • numbernumberRequired

    The value to be rounded.

  • significancenumberOptional

    The multiple to which number is to be rounded. If significance is omitted, its default value is 1.

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 Google Sheets

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