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
Number | The number to be rounded. |
Multiple | The 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)
Example 2
=MROUND(-16,-9)
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.