Skip to main content
Version: Streamsheets 2.4

FLOOR

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

Syntax

=FLOOR(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
=FLOOR(4.32, 0.05)4.3
=FLOOR(-45.67, 2-46
=FLOOR(-45.67, -2)-44