Documentation/Calc Functions/FLOOR.PRECISE

Function name:
FLOOR.PRECISE

Category:
Mathematical

Summary:
Rounds a number to the nearest multiple of a significance value. In all cases, the number is rounded down (toward -∞).

Syntax:
FLOOR.PRECISE(Number [; Significance])

Returns:
Returns a real number that is the rounded value and is an integer multiple of the significance value.

Arguments:
Number is a real number, or a reference to a cell containing that number, that is the value to be rounded.

Significance is a real number, or a reference to a cell containing that number, that is the significance value to be used. If omitted, Significance defaults to 1. The sign of Significance is ignored.


 * If either argument is non-numeric, then FLOOR.PRECISE reports a #VALUE! error.
 * If either Number or Significance is equal to 0, then FLOOR.PRECISE returns 0.

Related LibreOffice functions:
CEILING

CEILING.MATH

CEILING.PRECISE

CEILING.XCL

FLOOR

FLOOR.MATH

FLOOR.XCL

INT

ISO.CEILING

ODF standard:
None

Equivalent Excel functions:
FLOOR.PRECISE