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.
FLOOR(base_number, multiple) -> rounded_number
- 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.
- rounded_number (type: Number)
- The base number rounded down to the given multiple.
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