The MROUND function allows you to round to any value you want and is particularly useful in financial/commerce applications where rounding to the nearest nickel/dime/quarter is required. This function is only available if Analysis AddIn is installed. It rounds the target value to any multiple that you specify.

To round the value in **A1** to the nearest nickel we use **=MROUND(A1; 0.05)**

Unlike the equivalent Excel function, **MROUND** in Calc allows negative numbers.

In fact, **MROUND()** is so useful – it can even be used to round the time to the nearest quarter hour. An example of this is shown below.