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.
- All versions
|Number||The number to be rounded.|
|Multiple||The multiple to which you want to round number.|
Firstly a reminder: Named ranges are added to ease of reading formulas.
- Use the ROUND for standard rounding.
- Use the ROUNDUP to always round up.
- Use the ROUNDDOWN to always round down.
If the number and multiplier has opposite signs (+/-), the #NUM! error is returned.