Skip to main content

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.