Excel - Microsoft Excel Mround Function

Description

The Excel Mround function rounds a supplied number up or down to the nearest multiple of a given number. 

The syntax of the function is: 

MROUND( number, multiple ) 

Where the arguments are as follows: 

Mround Function Examples

The following spreadsheet shows several examples of the Mround function: 

The above examples show how the Mround function rounds the supplied number up or down, to the nearest multiple of the supplied multiple argument. 

Mround Function Error

If you get an error from the Excel Mround function, this is likely to be the #NUM! error : 

Common Error