Documentation/Calc Functions/FLOOR.PRECISE
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
FLOOR.PRECISE
Category:
Mathematical
Summary:
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.
Syntax:
FLOOR.PRECISE(Number [; Significance])
Returns:
Returns an integer value.
Arguments:
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.
Additional details:
Examples:
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 |
Related LibreOffice functions:
ODF standard:
None
Equivalent Excel functions:
FLOOR.PRECISE