<< Click to Display Table of Contents >> FLOOR (round down to a multiple of base) |
Syntax:
FLOOR(Number, Base)
Description:
Rounds Number down (towards zero) to the nearest multiple of Base.
Positive numbers are rounded to the nearest multiple of Base that is smaller than Number.
Negative numbers are rounded to the nearest multiple of Base that is larger than Number.
Number and Base must have the same sign, otherwise the function returns a #NUM! error value.
Example:
FLOOR(42.5, 1) returns 42
FLOOR(-42.5, -1) returns -42
FLOOR(21, 5) returns 20
FLOOR(12.3456, 0.01) returns 12.34
See also: