Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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