# MROUND

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.* You can use the ROUNDDOWN function to round down to a specified number of digits.* You can use the ROUNDUP function to round up to a specified number of digits.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.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!