Translations:Documentation/Calc Functions/CEILING/20/en

From The Document Foundation Wiki
Jump to: navigation, search
Formula Description Returns
=CEILING(11.5) rounds up 11.5 to nearest multiple of +1(default) 12
=CEILING(-11.5) rounds up -11.5 to nearest multiple of -1(default) -11
=CEILING(-11;-2) rounds up -11 to nearest multiple of -2 -10
=CEILING(-10;-3;1) rounds down -10 to nearest multiple of -3 under mode 1 which is not 0 hence result will be away from 0 -12
=CEILING(-11.67;-2;0) rounds up -11.67 to nearest multiple of -2 under mode 0 i.e. towards 0 -10
=CEILING(-11.67;-2;1) rounds down -11.67 to nearest multiple of -2 under mode 1 which is not 0 hence result will be away from 0 -12
=CEILING(11.5;-1) rounds up 11.5 to nearest multiple of -1 but due to opposite sign this will return an error value Err:502