Skip to content
Excel

CEILING.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.

=CEILING.PRECISE(number, [significance])

CEILING.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.

CEILING.PRECISE examples

Formulas you'll actually reuse.

  1. Up to the next half — like CEILING.MATH, but the sign of the significance is ignored:

    =CEILING.PRECISE(B2, 0.5)

    Result8

  2. Negatives always round toward positive infinity: −23 becomes −20:

    =CEILING.PRECISE(-B2, 10)

    Result-20

CEILING.PRECISE in Google Sheets

Same name — your formula ports as-is.

Try CEILING.PRECISE in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.