The ‘MROUND’ function in Excel rounds a number up or down to the nearest multiple of significance. For example, if the significance input was 50; multiples would include 50, 100, 150, etc. In this instance, if our input number was 102, the MROUND formula would round DOWN to 50. However, if the input number was 98, the MROUND formula would round UP to 50.
Note: the FLOOR function is very similar; except it only rounds down to the nearest multiple of significance (rather than rounding both up and down).
- number – input number that you wish to round down
- multiple – the number which will be multiplied in order to find the closest multiple to the input number.
Note: Both the ‘number’ and ‘multiple’ arguments must be the same sign (i.e. positive/negative).
The MROUND function will round a number up or down to the nearest multiple of the significance input.