How to use CEILING function in Excel

This article describes the formula syntax and usage of the CEILING function in Microsoft Excel.

Purpose 

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

Sample Usage

CEILING(23.25,0.1)

CEILING(A2,1)

Syntax

CEILING(value, [factor])

  • value – The value to round up to the nearest integer multiple of.factor
  • factor – [OPTIONAL – 1 by default] – The number to whose multiples willvalue to .be rounded.
    • factor may not be to.0

Notes

  • value And factor must have the same sign; that is, they must both be positive or both negative.
  • CEILING Is most often used with set factor as to a ’round’ number as or0.1 0.01 to round to a particular decimal place. However, factor can, in fact, be any number of the same sign as, value e.g. CEILING(23.25,0.18) which results in,23.4 which is 0.18 * 130. This can be used, for instance, to round up to a particular denomination of currency (e.g. 0.25 or 0.05 USD).

Example:

Result Formula
126.9 =CEILING(126.85, 0.1)
127 =CEILING(126.85, 1)
128 =CEILING(126.85, 2)
130 =CEILING(126.85, 10)
200 =CEILING(126.85, 100)