# CEILING

### Definition of CEILING

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`value`

will be rounded.`factor`

may not be equal 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`factor`

set to a 'round' number such as`0.1`

or`0.01`

in order 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).

### See Also

`FLOOR`

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

`TRUNC`

: Truncates a number to a certain number of significant digits by omitting less significant digits.

`ROUNDUP`

: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

`ROUNDDOWN`

: Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

`ROUND`

: Rounds a number to a certain number of decimal places according to standard rules.

`MROUND`

: Rounds one number to the nearest integer multiple of another.

`INT`

: Rounds a number down to the nearest integer that is less than or equal to it.

### To use the CEILING Formula, simply begin with your edited Excellentable:

### Then begin typing the CEILING formula in the area you would like to display the outcome:

### By adding the values you would like to calculate, Excellentable generates the outcome:

**Error.**

User does not have sufficient privileges to access this Content

Learn More