Translations:Documentation/Calc Functions/CEILING.PRECISE/19/en

From The Document Foundation Wiki
Jump to: navigation, search
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