FLOOR.MATH
Description
Rounds a number down to the nearest integer, based on the significance and mode that
you specify.
Syntax
FLOOR.MATH(
value
, [
significance
], [
mode
])
- value: The number to round.
- significance: The multiple of significance to round the number down to. If you omit the argument, the function uses the value 1, which causes the function to round the number down to the next smaller integer.
- mode: If you specify any number other than zero, the function rounds negative numbers up (toward zero).
Example
Formula | Result |
|---|---|
=FLOOR.MATH(12.34,1) | 13 |
=FLOOR.MATH(12.34,10) | 20 |
=FLOOR.MATH(-12.34,1) | -12 |
=FLOOR.MATH(-12.34,1) | -13 |
=FLOOR.MATH(-12.34,-1,1) | -13 |