From The Document Foundation Wiki
Formula |
Description |
Returns
|
=MROUND(15.5;3) |
rounds 15.5 to nearest multiple of 3, i.e. 15.5 is closer to 15 (= 3*5) than to 18 (= 3*6) |
15
|
=MROUND(1.4;0.5) |
rounds 1.4 to nearest multiple of 0.5, i.e. 1.4 is closer to 1.5 (= 0.5*3) than to 1.0 (= 0.5*2) |
1.5
|
=MROUND(11;2) |
rounds 11 to nearest multiple of 2, i.e. 11 is as closer to 12 (= 2*6) as to 10 (= 2*5) so taking higher value |
12
|
=MROUND(-11;2) |
rounds -11 to nearest multiple of 2 but -11 is as closer to -12 (= 2*-6) as to 10 (= 2*-5) so taking higher absolute valued multiple |
-12
|
=MROUND(-11;-2) |
rounds -11 to nearest multiple of 2,ignoring the sign |
-12
|
=MROUND(11;-2) |
rounds -11 to nearest multiple of 2, ignoring the sign |
12
|