Documentation/Calc Functions/FLOOR.XCL/en

Function name:
FLOOR.XCL

Category:
Mathematical

Summary:
Rounds a number to the nearest multiple of a significance value. The direction of rounding is dependent on the signs of the funtion's two arguments.

Syntax:
FLOOR.XCL(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 either Number or Significance is non-numeric, then FLOOR.XCL reports a #VALUE! error.
 * If Number is equal to 0, then FLOOR.XCL returns 0.
 * If Significance is equal to 0, then FLOOR.XCL reports an invalid argument error (Err:502).
 * If Number is positive and Significance is negative, then FLOOR.XCL reports an invalid argument error (Err:502).

The signs of the Number and Significance arguments define the direction of rounding as defined in the following table.

Related LibreOffice functions:
CEILING

CEILING.MATH

CEILING.PRECISE

CEILING.XCL

FLOOR

FLOOR.MATH

FLOOR.PRECISE

INT

ISO.CEILING

ODF standard:
NONE

Equivalent Excel functions:
FLOOR