The MROUND function rounds a number to the nearest multiple of a specified number. In this guide, we’re going to show you how to use the MROUND function and also throw in some tips and error handling methods.


Supported versions

  • All versions

Syntax

MROUND(number,multiple)


Arguments

NumberThe number to be rounded.
MultipleThe multiple to which you want to round number.


Examples

Firstly a reminder: Named ranges are added to ease of reading formulas.

Example 1

=MROUND(16,9)
formula returns 18. The 9 has 2 multiples near to 16, which are 9 and 18. Because the 18 is the nearest, the formula returns 18.

Example 2

=MROUND(-16,-9)
formula returns -18 according to similar logic with Example 1. On the other hand, if the number is negative, choose a negative number for the multiplier as well.

Download Workbook


Tips

  • Use the ROUND for standard rounding.
  • Use the ROUNDUP to always round up.
  • Use the ROUNDDOWN to always round down.

Issues

#NUM!

If the number and multiplier has opposite signs (+/-), the #NUM! error is returned.