Rounds a number down to the nearest multiple of a significance value.
For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored.
FLOOR.PRECISE(Number [; Significance])
Returns an integer value.
Number is the number that is to be rounded, or a reference to a cell containing the number.
Significance (optional) is the value, or a reference to a cell containing the value, to whose multiple Number is to be rounded. It defaults to 1.
|=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|
Related LibreOffice functions:
Equivalent Excel functions: