Translations:Documentation/Calc Functions/MROUND/19/en

From The Document Foundation Wiki
Jump to: navigation, search
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