Documentation/Calc Functions/FLOOR.PRECISE

From The Document Foundation Wiki
Jump to: navigation, search

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:

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.

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:

FLOOR

FLOOR.MATH

FLOOR.XCL

CEILING

INT

ODF standard:

None

Equivalent Excel functions:

FLOOR.PRECISE