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: Integer multiples - use a consistent formula Decimal multiples - give random results

REMARKS

* This function is only available for backwards compatibility and should not be used.
* You should use the ROUND function instead with the formula =ROUND(number/multiple, 0) * multiple
* For an illustrated example refer to the page under Advanced Functions
* If "number" is an exact multiple of "multiple", there is no rounding.
* If "number" or "multiple" are zero, then 0 is returned.
* If "multiple" is an integer, numbers are rounded up when remainder of number/multiple >= multiple/2
* If "multiple" is an integer, numbers are rounded down when remainder of number/multiple < multiple/2.
* If "multiple" is not an integer, then you will get random results.
* If "number" and "multiple" have different signs, then #NUM! is returned.
* 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.
* You can use the CEILING.MATH function to return the number rounded up by default to a certain multiple.
* You can use the FLOOR.MATH function to return the number rounded down by default to a certain multiple.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=MROUND(0.9, 1) = 1.00
2	=MROUND(1.1, 1) = 1.00
3	=MROUND(1.5, 3) = 3.00
4	=MROUND(9.1, 9) = 9.00
5	=MROUND(15.1, 15) = 15.00
6	=MROUND(1.1, 3) = 0.00
7	=MROUND(1.5, 3) = 3.00
8	=MROUND(1.9, 3) = 3.00
9	=MROUND(2.1, 3) = 3.00
10	=MROUND(4.51, 9) = 9.00
11	=MROUND(7.51, 15) = 15.00
12	=MROUND(13, 2) = 14.00
13	=MROUND(-13, -2) = -14.00
14	=MROUND(15, 0) = 0.00
15	=MROUND(-15, 0) = 0.00
16	=MROUND(6.05, 0.1) = 6.00
17	=MROUND(7.05, 0.1) = 7.10
18	=MROUND(NOW(), "0:20") = 6:40:00 AM
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. The only multiple of 0 is zero.
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. This is rounded down to 6.0
17 - What is the number 7.05 rounded to the nearest 0.1. This is rounded up to 7.1
18 - What is the current time rounded to the nearest 20 minutes.
19 - The numbers have different signs.
20 - Both the numbers are not numeric.