Google Sheets' MROUND function makes it easy to round a number up or down to the nearest 5, 10, or other specified multiple. For example, you could use the function to round the cost of items up or down to the nearest five cents ($0.05) or 10 cents ($0.10) to avoid having to deal with pennies ($0.01) in change.

Unlike formatting options that let you change the number of decimal places displayed without changing the value in the cell, the MROUND function, like other Google Sheets rounding functions, changes the value of the data. Therefore, using this function to round data will affect the results of calculations.

The syntax of a function refers to the layout of the function and includes the function name, parentheses, and arguments.

The syntax for the MROUND function is: