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 the nearest integer.
* You can use the ROUNDUP function to round up to the nearest integer.
* 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!