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

    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