MROUND Function in Excel – Round to nearest multiple in Excel

MROUND Function in Excel rounds the number up or down to the nearest multiple of the supplied argument (multiple)

Syntax of MROUND Function in Excel

MROUND( number,multiple)

number – The number to be rounded

multiple – The number used to choose the nearest multiple while rounding

 

Example of MROUND Function in Excel

Formula

MROUND Function in Excel 1

  • In Row number 2 the value 97 is Rounded up to the nearest multiple of 10 i.e. 100
  • In Row number 3 the value 9 is Rounded down to the nearest multiple of 4 i.e. 8
  • In Row number 4 the value 11 is rounded up to the nearest multiple of 4 i.e 12
  • In Row number 5 the value 33.3 is rounded down to the nearest multiple of 1 i.e 33
  • In Row number 6 the value -23.3 is rounded up to the nearest multiple of -1 i.e -23

So the result will be

Result

MROUND Function in Excel 2

Note: #VALUE! Error occurs if the supplied arguments are non-numeric.

              #NUM!   – Error occurs if the multiple argument and Number argument have different signs

Example:

MROUND Function in Excel 3

previous-small MROUND Function in Excel                                                                                                                next_small MROUND Function in Excel