### MROUND(number, multiple)

Returns the number rounded to the desired multiple.

 number The number you want to round. multiple The multiple to which you want to round.

#### Remarks

 * This function rounds up, if the remainder of dividing "number" by "multiple" is greater than or equal to half the value of "multiple".* This function rounds down, if the remainder of dividing "number" by "multiple" is less than half the value of "multiple".* If "number" and "multiple" have different signs, then #NUM! is returned.* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.* You can use the ROUND function to round to a specified number of digits.* For the Microsoft documentation refer to support.office.com

 A 1 =MROUND(10,3) = 9 2 =MROUND(-10,-3) = -9 3 =MROUND(1.58,0.5) = 1.5 4 =MROUND(1.3,0.2) = 1.4 5 =MROUND(1234,100) = 1200 6 =MROUND(1234,1000) = 1000 7 =MROUND(5,-2) = #NUM! 8 =MROUND(-5,2) = #NUM! 9 =MROUND(10,"some text") = #VALUE!