CEILING
Description
Rounds a number up to the nearest integer, based on the significance and mode that
you specify.
Syntax
CEILING(
number
, [
significance
], [
mode
])
- number: The number to round up.
- significance: The multiple of significance to round the number up to. If you omit the argument, the function uses the value 1, which causes the function to round the number up to the next larger integer.
- mode: If you specify -1, the function rounds negative numbers down, becoming more negative. If you specify any other number, the function rounds negative numbers up, toward zero.
Example
Formula | Result |
|---|---|
=CEILING(12.34) | 13 |
=CEILING(12.34,0.1) | 12.4 |
=CEILING(12.34,0.5) | 12.5 |
=CEILING(12.34,10) | 20 |
=CEILING(-12.34,-1) | -13 |
=CEILING(-12.34,-0.1) | -12.4 |
Notes
- numberandsignificancemust have the same sign.
- This function does the same action as CEILING.MATH().