If you find any post useful then, please do share with others. Thanks!

Popular Posts

Contact

Email me

Need help and that also free? I like to learn this way, in case of any question or for a small task, please feel free to email me with details and example data, if required.

Thursday, June 30, 2016

Excel MROUND Function


The Excel MROUND function is to round values to the nearest multiple. This function is available in Excel 2007 & above.

The syntax of this function is MROUND(number, multiple). Here the number is the cell or value and multiple is what you want your value to round to.

We can round the time as well. For example we have start times and want to round it to nearest 15 minutes.

When we want to round time, the multiple is written is double quotes same as time format e.g. =MROUND(A2,”0:15”).

And for normal numbers the multiple is entered without double quotes.

And when we round negative numbers, the multiple is entered in same sign, otherwise we will get error.

And another point to note that this function will round up or down to the nearest multiple and not in a fixed direction.

For fixed direction, we can use ROUNDUP or ROUNDDOWN functions.

Examples

Round some prices to nearest 5 cents
Price
Formula
Rounded Value
$7.99
MROUND(A3,0.05)
8
$7.45
MROUND(A4,0.05)
7.45
$7.49
MROUND(A5,0.05)
7.5
$7.44
MROUND(A6,0.05)
7.45
Round some start times to nearest 15 minutes
Start Time
Formula
Rounded Value
6:53 AM
MROUND(A10,"0:15")
7:00:00 AM
5:08 AM
MROUND(A11,"0:15")
5:15:00 AM
9:23 AM
MROUND(A12,"0:15")
9:30:00 AM
2:38 AM
MROUND(A13,"0:15")
2:45:00 AM
Round a negative value
Price
Formula
Rounded Value
($7.92)
MROUND(A18,-0.05)
-7.9

 

1 comment:

  1. Your blog is nice and informative about how to be a master of excel. To reach out the target audience let us provide the updated business and consumer database.our lists are prepacked and customized which helps the customer to meet the exact requirements. I would like to share about the leading mailing list vendor Business & Consumer Database

    ReplyDelete