These docs are for v1.0. Click to read the latest docs for v1.2.

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

ArgumentTypeDescription
valueNumberThe value to round up
factorNumber(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