Documentation/Calc Functions/CEILING.PRECISE/en

Function name:
CEILING.PRECISE

Category:
Mathematical

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

Syntax:
CEILING.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 CEILING.PRECISE reports a #VALUE! error.
 * If either Number or Significance is equal to 0, then CEILING.PRECISE returns 0.

Related LibreOffice functions:
CEILING

CEILING.MATH

CEILING.XCL

FLOOR

FLOOR.MATH

FLOOR.PRECISE

FLOOR.XCL

INT

ISO.CEILING

ODF standard:
None

Equivalent Excel functions:
CEILING.PRECISE