Skip to content
Google Sheets

CEILING.MATH function in Google Sheets

Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.

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

CEILING.MATH syntax and parameters

Three arguments, one required.

  • numbernumberRequired
  • significancenumberOptional
  • modenumberOptional

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 Excel

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