MROUND |
MROUND(number, multiple) |
Returns the number rounded to a certain 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 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 |
|
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