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.
If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions.
|=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: