CEILING
Returns a given number rounded up to the nearest multiple of specified significance. The multiple to use for rounding is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned. To round down use FLOOR().
Syntax
=CEILING(Number, Significance)
Arguments
| Name | Type | Description |
|---|---|---|
| Number | Number | The number to round |
| Significance | Number | The multiple to use when rounding |
Return
| Type | Description |
|---|---|
| Number | The rounded number or an error value. |
Examples
| Formula | Result | Comment |
|---|---|---|
| 4.35 | |
| -2 |