The function FLOOR rounds a Number down to the nearest specified multiple.
This function takes a Number as input. By default, it will return the given Number rounded down to the nearest integer, though it also accepts, as an option, another Number as input, which specifies which place to round down to.
Declaration
FLOOR(base_number, multiple) -> rounded_number
Parameters
base_number (required, type: Number)
Any number. This is the number that will be rounded down.
multiple (optional, type: Number)
The multiple to round down to.
For instance, a multiple of 10 will round the given number down to the nearest ten, while a multiple of 0.01 will round the given number down to the nearest hundredth.
Return Values
rounded_number (type: Number)
The base number rounded down to the given multiple.
Examples
The following example takes the number 21.9 and rounds it down to the nearest integer, the ones place being the default place that FLOOR rounds down to. Note that, despite the number occupying the tenths place in the base number being 9 – the largest number that could possibly occupy it – FLOOR still rounds down:
FLOOR(21.9) -> 21
The following example takes the number 389 and rounds it down to the nearest hundreds place. Note again that FLOOR always rounds the base number down:
FLOOR(389, 100) -> 300
The following example takes the number 999.999999 and rounds it down to the tenths place. Note one last time that FLOOR always rounds the base number down:
FLOOR(999.999999, 0.1) -> 999.9