Description
Rounds a number up to the nearest multiple of a specified significance.
Syntax
CEILING ( number, significance )
| Parameter | Description |
|---|---|
| number | The value to round. |
| significance | The multiple to which to round. |
Remarks
Regardless of the sign of the number, the value is rounded up, away from zero. If number is an exact multiple of significance, no rounding occurs.
If the number or significance is non-numeric, the error #VALUE! is returned. When the arguments have opposite signs, the error #NUM! is returned.
Examples
This function returns 1.25:
CEILING(1.23459, .05)
This function returns -150:
CEILING(-148.24, -2)
See also