FLOOR
Rounds a number down, to the nearest specified multiple of significance.
Syntax
FLOOR(number;significance)
Number is the numeral value you wish to round.
Significance the multiple based on which you wish the rounding to be performed.
Comment
If either of the entries is non-numeral, the FLOOR function returns the error value #VALUE!.
If the entries Number and Significance have different signs, the FLOOR function returns the error value #NUM!.
Regardless of the number’s sign, a value is rounded down when it is adjusted away from zero. If the entry Number is an exact multiple of the entry Significance, then the value is not rounded.