Skip to content
Excel

CEILING function in Excel

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

=CEILING(number, significance)

CEILING syntax and parameters

Two arguments, two required.

  • numbernumberRequired

    The value you want to round.

  • significancenumberRequired

    The multiple to which you want to round.

CEILING examples

Formulas you'll actually reuse.

  1. A price rounded up to the next 5 cents:

    =CEILING(B2, 0.05)

    Result23.8

  2. An order quantity rounded up to the next pallet of 25:

    =CEILING(B2, 25)

    Result125

CEILING in Google Sheets

Same name — your formula ports as-is.

Try CEILING in the playground

Edit the example — nothing to install.

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

Loading the editor…

CEILING errors

What they mean — and the fixes.

  • #NUM!

    The number and the significance have different signs — use CEILING.MATH for negatives.

Related functions

More ways Excel gets this done.