Excel MROUND function

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).

Syntax

=MROUND(number,multiple)

Arguments

  • 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).

Function category

Math and trigonometry

Returns

The MROUND function will round a number up or down to the nearest multiple of the significance input.

Download Excel File

 Example of MROUND Formula

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.