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
|