Skip to content
ExcelExcel 2013+

ISO.CEILING function in Excel

Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance

=ISO.CEILING(number, [significance])

ISO.CEILING syntax and parameters

Two arguments, one required.

  • numbernumberRequired
  • significancenumberOptional

ISO.CEILING examples

Formulas you'll actually reuse.

  1. Up to the next quarter — identical to CEILING.PRECISE:

    =ISO.CEILING(B2, 0.25)

    Result7.75

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

    =ISO.CEILING(-B2, 5)

    Result-20

ISO.CEILING in Google Sheets

Same name — your formula ports as-is.

Try ISO.CEILING in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.