Documentation/Calc Functions/CEILING.PRECISE

From The Document Foundation Wiki
Jump to: navigation, search
This page contains changes which are not marked for translation.

Other languages:
dansk • ‎English

Function name:

CEILING.PRECISE

Category:

Mathematical

Summary:

Rounds a number up to the nearest multiple of a significance value.

For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored.

Syntax:

CEILING.PRECISE(Number [; Significance])

Returns:

Returns an integer value.

Arguments:

Number (required) is the real number that is to be rounded, or a reference to a cell containing the number.

Significance (optional) is the real number value, or a reference to a cell containing the value, to whose multiple Number is to be rounded. It's sign is ignored.

Additional details:

Note pin.svg

This function calculates identical results to the ISO.CEILING function.


Examples:

Formula Description Returns
=CEILING.PRECISE(11.5) rounds up 11.5 to nearest multiple of +1(default) 12
=CEILING.PRECISE(-11.5) rounds up -11.5 to nearest multiple of -1(default) -11
=CEILING.PRECISE(-11;-2) rounds up -11 to nearest multiple of -2 -10
=CEILING.PRECISE(-11;2) rounds up -11 to nearest multiple of -2 rounding up towards 0 ignoring the sign of significance being passed -10

Related LibreOffice functions:

CEILING

ISO.CEILING

CEILING.MATH

CEILING.XCL

FLOOR

ODF standard:

None

Equivalent Excel functions:

CEILING.PRECISE