Table of Contents
The MROUND function in Excel allows users to round a number to the nearest multiple specified by the user. This function is useful for situations where rounding a number to the nearest whole number is not precise enough. To use the MROUND function, simply input the number you want to round and the multiple you want to round to, and the function will return the rounded number. This can be helpful in a variety of applications, such as financial calculations or data analysis, where accuracy is crucial. Overall, the MROUND function in Excel provides a convenient and efficient way to round numbers to the nearest multiple.
MROUND returns a number rounded to the desired multiple.
Syntax
MROUND(number, multiple)
The MROUND function syntax has the following arguments:
Number Required. The value to round.
Multiple Required. The multiple to which you want to round number.
Remarks
MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.
The Number and Multiple arguments must have the same sign. If not, a #NUM error is returned.
Example
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Formula | Description | Result |
|---|---|---|
=MROUND(10, 3) | Rounds 10 to the nearest multiple of 3. | 9 |
=MROUND(-10, -3) | Rounds -10 to the nearest multiple of -3. | -9 |
=MROUND(1.3, 0.2) | Rounds 1.3 to the nearest multiple of 0.2. | 1.4 |
=MROUND(5, -2) | Returns the #NUM! error message because -2 and 5 have different signs. | #NUM! |
Cite this article
stats writer (2024). How can I use the MROUND function in Excel to round a number to the nearest multiple?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-mround-function-in-excel-to-round-a-number-to-the-nearest-multiple/
stats writer. "How can I use the MROUND function in Excel to round a number to the nearest multiple?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-mround-function-in-excel-to-round-a-number-to-the-nearest-multiple/.
stats writer. "How can I use the MROUND function in Excel to round a number to the nearest multiple?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-mround-function-in-excel-to-round-a-number-to-the-nearest-multiple/.
stats writer (2024) 'How can I use the MROUND function in Excel to round a number to the nearest multiple?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-mround-function-in-excel-to-round-a-number-to-the-nearest-multiple/.
[1] stats writer, "How can I use the MROUND function in Excel to round a number to the nearest multiple?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the MROUND function in Excel to round a number to the nearest multiple?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.