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) |