Thus, using this function to round data affects the results of calculations.
To round numbers up or down without specifying the amount of rounding, use theROUNDUPor ROUNDDOWN functions instead.
The last two examples demonstrate how the function handles rounding up or down.
To see this in action:
Enter4.54intocellA1.
Clickcell C1in the worksheet to make it theactive cell.
This is where the results of the MROUND function will be displayed.
jot down theequal sign(=) followed byMROUND.
Type0.5to enter this number as the factor argument.
It should appear as=MROUND(A1,0.5).
Another way to enter the cell reference aside from typing it: Select cell A1 in the worksheet.
Enter a commato act as a separator between the function’s arguments.
PressEnterto enter a closing parenthesis [)] after the function’s argument and to complete the function.
The value 4.5 should appear in cell C1, which is the nearest multiple of 0.5 larger than 4.54.
