Excel Function: MROUND

The MROUND function returns a number rounded to the desired multiple.


=MROUND(number, multiple)

Round to 5 cents

In this example, the total cost is calculated using the following formula:

excel function table calculation mround

To round the total to 5 cents, add the MROUND function, then enter the number to round (here, B2*C2) and the multiple 0.05:

excel function mround