Documentation/Calc Functions/CEILING.XCL/en

Function name:
CEILING.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:
CEILING.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 CEILING.XCL reports a #VALUE! error.
 * If either Number or Significance is equal to 0, then CEILING.XCL returns 0.
 * If Number is positive and Significance is negative, then CEILING.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

FLOOR

FLOOR.MATH

FLOOR.PRECISE

FLOOR.XCL

INT

ISO.CEILING

ODF standard:
None

Equivalent Excel functions:
CEILING