Google Sheets MROUND function is a powerful tool for rounding numbers to the nearest integer multiple. In this article, we’ll explore how to use the MROUND function in Google Sheets and discover its key differences compared to the ROUND function.
The MROUND function takes two arguments: “value” and “factor”. The “value” is the number you want to round, and the “factor” is the number you want to round it to the nearest multiple of. It’s important to note that both arguments are required for the function to work properly.
MROUND Function – Syntax and Arguments
Syntax:
MROUND(value, factor)Arguments:
value– The number to round.factor– The number whose multiples the value will be rounded to.
Now, let’s dive into a few examples to quickly grasp the concept of using the MROUND function in Google Sheets.
Examples
In the following examples, we have a column (A2:A5) with values that we want to round to the nearest integer multiple of the corresponding factors in another column (B2:B5).
To better understand these MROUND() formulas, let’s focus on row #5, where the value is 22 (A5) and the factor is 8 (B5). We need to find the nearest integer multiple of the value.
To do this, we calculate the multiples of the factor 8:
1 x 8 = 8
2 x 8 = 16
3 x 8 = 24
In this case, the nearest integer multiple of the value 22 (A5) is 24, not 8 or 16. Therefore, the following formula in cell C5 returns 24:
=MROUND(A5, B5)I hope this clarifies the usage of the MROUND function. Now, let’s compare it to the ROUND function.
MROUND Vs. ROUND in Google Sheets
Both MROUND and ROUND are math functions, but their purposes are quite different.
The ROUND function is used to round a number to a specific number of decimal places according to standard rules. Let’s take a look at two examples:
Example 1
=ROUND(22.1254, 2)
Result: 22.13Example 2
=ROUND(22.1254, 1)
Result: 22.1On the other hand, the MROUND function is specifically designed for rounding to the nearest integer. It does not deal with decimal places.
Conclusion
Now that you have a practical understanding of the MROUND function in Google Sheets, you can use it to round time values as well. If you’re interested, check out our tutorial on how to round hours, minutes, and seconds using MROUND in Google Sheets.
That’s all for now! Enjoy exploring the powerful capabilities of Google Sheets. And remember, for more useful tips and tricks, visit Crawlan.com.
