Skip to content
ExcelExcel 2013+

CEILING.MATH function in Excel

Rounds a number up, to the nearest integer or to the nearest multiple of significance

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

CEILING.MATH syntax and parameters

Three arguments, one required.

  • numbernumberRequired

    (must be between -2.229E-308.and 9.99E+307.)

  • significancenumberOptional

    This is the number of significant digits after the decimal point to which number is to be rounded.

  • modenumberOptional

    This controls whether negative numbers are rounded toward or away from zero.

CEILING.MATH examples

Formulas you'll actually reuse.

  1. Timesheet hours rounded UP to the next half hour:

    =CEILING.MATH(B2, 0.5)

    Result8

  2. Negatives away from zero with mode 1 — −23 becomes −30, not −20:

    =CEILING.MATH(-B2, 10, 1)

    Result-30

CEILING.MATH in Google Sheets

Same name — your formula ports as-is.

Try CEILING.MATH in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.