Translations:Documentation/Calc Functions/FLOOR.PRECISE/19/en
Formula | Description | Returns |
---|---|---|
=FLOOR.PRECISE(11.5) | rounds down 11.5 to nearest multiple of 1(default) | 11 |
=FLOOR.PRECISE(-11.5) | rounds down -11.5 to nearest multiple of 1(default) | -12 |
=FLOOR.PRECISE(-11;-2) | rounds down -11 to nearest multiple of 2, ignoring the sign | -12 |
=FLOOR.PRECISE(-11;2) | rounds down -11 to nearest multiple of 2, ignoring the sign of significance being passed | -12 |