FLOOR

Owned by Charles Bishop (Deactivated)

Jan 30, 2018

Syntax

FLOOR(<number>;<number>)

Description

Rounds a number down, toward 0 (zero). The second value is the significance.

Examples

Column1	FLOOR() returns
123.45	123
37.888	37
-5.5	-6

Add a significance value to round down from a specific decimal position.

Column1	FLOOR(<column1>;3)
123.456789	123.456