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