Skip to content
Google Sheets

CEILING function in Google Sheets

Rounds a number up to the nearest integer multiple of specified significance.

=CEILING(value, [factor])

CEILING syntax and parameters

Two arguments, one required.

  • valuenumberRequired

    The value to round up to the nearest integer multiple of factor.

  • factornumberOptional

    [OPTIONAL: 1 by default] - The number to whose multiples value will be rounded. factor may not be equal to 0.

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 Excel

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