The MROUND function in Google Sheets is used to round a number to the nearest specified multiple. This can be particularly useful when you need to round numbers to the nearest whole number, nearest 0.5, or any other specified rounding multiple, depending on your needs.
The syntax of the MROUND function is:
MROUND(value, factor)
Follow the steps below to use MROUND in Google Sheets.
After opening Google Sheets, input the numbers you want to round and their respective rounding factors in two columns. Based on the given dataset, you would enter the "Number to Round" in column A and the "Rounding Factor" in column B.
Click on the first cell in column C (C2) where you want the rounded result for the first entry to appear. This column will display the results of the rounding operation.
In cell C2, type in the MROUND formula referencing the first number and its rounding factor. The formula will be =MROUND(A2, B2). This will round the number in A2 (2.3) to the nearest multiple specified in B2 (0.5).
Hit Enter to execute the formula. Cell C2 will now show 2.5, indicating that 2.3 has been rounded to the nearest 0.5.
To apply the rounding formula to the rest of your data, click on C2 where you just entered your formula. Notice the small square (fill handle) at the bottom right corner of the cell. Drag this handle downwards to fill the cells below with the formula, automatically adjusting it for each row.
For rows where the rounding factor is different, the formula you entered will automatically adjust since it references the cells directly. So, whether the rounding factor is 0.5 or 10, the formula will use the respective value in column B to round the number in column A.
We hope that you now have a better understanding of what MROUND in Google Sheets is and how to use the Google Sheets MROUND function. If you enjoyed this article, you might also like our article on how to use the WEEKNUM function in Google Sheets or our article on how to connect Jira to Google Sheets.
