Documentation/Calc Functions/ISO.CEILING/en

Function name:
ISO.CEILING

Category:
Mathematical

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

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

Related LibreOffice functions:
CEILING

CEILING.MATH

CEILING.PRECISE

CEILING.XCL

FLOOR

FLOOR.MATH

FLOOR.PRECISE

FLOOR.XCL

INT

ODF standard:
None

Equivalent Excel functions:
ISO.CEILING