MROUND

MROUND(number, multiple)

Returns the number rounded to a certain multiple.

number	The number you want to round.
multiple	The multiple you want the number rounded to.

REMARKS

* For an illustrated example refer to the Rounding Functions page.
* Positive numbers are rounded up (when remainder of number/multiple >= multiple/2 ) and rounded down when (< multiple/2).
* Negative numbers are rounded up (when remainder of number/multiple >= multiple/2 ) and rounded down when (< multiple/2).
* If "number" is an exact multiple of "multiple", there will be no rounding.
* If either "number" or "multiple" are zero, then 0 is returned.
* If "number" and "multiple" have different signs, then #NUM! is returned.
* You can use the CEILING.MATH function to round up by default to a certain multiple.
* You can use the FLOOR.MATH function to round down by default to a certain multiple.
* You can use the INT function to return a number rounded down to the nearest integer.
* You can use the EVEN function to return the number rounded to the nearest even integer.
* You can use the ODD function to return the number rounded to the nearest odd integer.
* You can use the ROUND function to round to a certain number of decimal places or digits.
* You can use the ROUNDDOWN function to round towards zero to a certain number of decimal places or digits.
* You can use the ROUNDUP function to round away from zero to a certain number of decimal places or digits.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=MROUND(1.9, 1) = 2
2	=MROUND(1.1, 1) = 1
3	=MROUND(3.1, 3) = 3
4	=MROUND(9.1, 9) = 9
5	=MROUND(15.1, 15) = 15
6	=MROUND(1.1, 3) = 0
7	=MROUND(1.5, 3) = 3
8	=MROUND(1.9, 3) = 3
9	=MROUND(2.1, 3) = 3
10	=MROUND(4.51, 9) = 9
11	=MROUND(7.51, 15) = 15
12	=MROUND(13, 2) = 14
13	=MROUND(-13, -2) = -14
14	=MROUND(15, 0) = 0
15	=MROUND(-15, 0) = 0
16	=MROUND(6.05, 0.1) = 6.0
17	=MROUND(7.05, 0.1) = 7.1
18	=MROUND(NOW(), "0:20") = 2:40:00 PM
19	=MROUND(-13, 2) = #NUM!
20	=MROUND("", 1) = #VALUE!

1 - What is the number 1.9 rounded to the nearest multiple of 1. This number is rounded up.
2 - What is the number 1.1 rounded to the nearest multiple of 1. This number is rounded down.
3 - What is the number 3.1 rounded to the nearest multiple of 3. This number is rounded down.
4 - What is the number 9.1 rounded to the nearest multiple of 9. This number is rounded down.
5 - What is the number 15.1 rounded to the nearest multiple of 15. This number is rounded down.
6 - What is the number 1.1 rounded to the nearest multiple of 3. This number is rounded down.
7 - What is the number 1.5 rounded to the nearest multiple of 3. This number is rounded up.
8 - What is the number 1.9 rounded to the nearest multiple of 3. This number is rounded up.
9 - What is the number 2.1 rounded to the nearest multiple of 3. This number is rounded up.
10 - What is the number 4.51 rounded to the nearest multiple of 9. This number is rounded up.
11 - What is the number 7.51 rounded to the nearest multiple of 15. This number is rounded up.
12 - What is the number 13 rounded to the nearest multiple of 2. This number is rounded up.
13 - What is the number -13 rounded to the nearest multiple of -2. This number is rounded down.
14 - What is the number 15 rounded to the nearest multiple of 0.
15 - What is the number -15 rounded to the nearest multiple of 0.
16 - What is the number 6.05 rounded to the nearest 0.1.
17 - What is the number 7.05 rounded to the nearest 0.1.