MROUND

MROUND(number, multiple)

Returns the number rounded to a certain multiple.

numberThe number you want to round.
multipleThe 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 either "number" or "multiple" are zero, then 0 is returned.
* If "number" and "multiple" have different signs, then #NUM! is returned.
* If "multiple" is a decimal, then
* You can use the CEILING.MATH function to round up to the nearest integer or multiple.
* You can use the FLOOR.MATH function to round down to the nearest integer or multiple.
* You can use the INT function to return a number rounded down to the nearest 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 down to a certain number of decimal places or digits.
* You can use the ROUNDUP function to round up 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") = 6:20: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.
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.

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top