CEILING Function
Rounds a number away from 0 (zero) to the next instance of multiple. If multiple is not specified, the number rounds away from 0 to the next integer.
Syntax
CEILING(number, multiple )
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| number |
Required |
Number |
The number to round. |
| multiple |
Required |
Number |
The multiple to round to. |
Remarks
Number and multiple must have the same signs, or a #NUM! error is returned. If either number or multiple cannot be converted to a value, a #VALUE! error is returned. If either number or multiple is 0, the result is 0.
Example 1
CEILING(3.7)
Returns 4
Example 2
CEILING(-3.7)
Returns -4
Example 3
CEILING(3.7, 0.25)
Returns 3.75