Documentation/Calc Functions/CEILING.PRECISE
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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:
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:
ODF standard:
None
Equivalent Excel functions:
CEILING.PRECISE