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