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
|