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