FLOOR
The FLOOR function rounds a number (towards zero) to the nearest specified multiple of significance.
Syntax
Arguments
value - Number or reference. This is a required argument.
significance - Multiple to which the number should be rounded. This is an optional argument. If missing, the number is rounded to the nearest integer less than the number.
Example
Returns 9 which is the closest multiple of 3 less than 11
Excel Equivalent
Last updated