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