« Looking up data in tables V | Main | Conditional Formatting IV : Masking errors »
April 07, 2005
Rounding to the nearest nickel: MROUND()
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.
Posted by Dave at April 7, 2005 09:12 PM