Translations:Documentation/Calc Functions/CEILING.PRECISE/19/en
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 |