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

    From The Document Foundation Wiki
    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