CEIL
Rounds up (to a lesser absolute value) to the nearest multiple of the specified factor. Defaults to a factor of 1.
Syntax
=CEIL(value, factor)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number | The value to round up |
| factor | Number | (Optional) Specified factor |
Examples
=CEIL(3.14)→4
Rounds the value 3.14 up to the nearest multiple of 1
=CEIL(10, 4)→12
Rounds the value 10 up to the nearest multiple of 4
=CEIL(-10, 4)→-12
Rounds the value -10 up to the nearest multiple of 4
Updated 9 months ago