Description Rounds a number up to the nearest multiple of a specified significance.
Syntax CEILING ( number, significance )
| Argument | 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 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:
This function returns 150:
See Also EVEN, FLOOR, INT, ODD, ROUND, TRUNC
