The FLOOR function rounds a number toward zero to the nearest multiple of the specified factor. Both arguments are number values.
FLOOR(num-to-round, factor)
num-to-round: The number to be rounded.
factor: The number to use to determine the closest multiple. factor must have the same sign as num-to-round.
Examples |
|---|
=FLOOR(0.25, 1) returns 0, the nearest multiple of 1 that is less (closer to zero) than 0.25. =FLOOR(1.25, 1) returns 1, the nearest multiple of 1 that is less than 1.25. =FLOOR(5, 2) returns 4, the nearest multiple of 2 that is less than 5. =FLOOR(73, 10) returns 70, the nearest multiple of 10 that is less than 73. =FLOOR(-0.25, -1) returns 0, the nearest multiple of -1 that is greater (closer to zero) than -0.25. =FLOOR(9, 2.5) returns 7.5, the nearest multiple of 2.5 that is less than 9. |