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

    From The Document Foundation Wiki
    Formula Description Returns
    =CEILING.XCL(14.5;4) rounds up 14.5 to nearest multiple of 4 16
    =CEILING.XCL(-11;2) rounds up -11 to nearest multiple of 2 -10
    =CEILING.XCL(-11;-2) rounds down -11 to nearest multiple of 2 and negative sign will round down i.e. away from 0 -12
    =CEILING.XCL(7;4) rounds up 7 to nearest multiple of 4 8
    =CEILING.XCL(11.5) Significance value is required so it will return an error value Err:511
    =CEILING.XCL(11,-2) Significance value is negative but Number is positive so it will return an error value Err:502