Skip to main content
Version: Streamsheets 2.4

CEILING

Returns a given number rounded up to the nearest multiple of specified significance. To round down use FLOOR().

Syntax

=CEILING(Number, Significance)

Arguments

NameDescription
NumberThe number to round
SignificanceThe multiple to which should be rounded

Return Value

The rounded number or an error value.

Example

FunctionResult
=CEILING(4.32, 0.05)4.35
=CEILING(-2.5, 2)-2