OpenOffice3.org Calc 3. Mathematical Functions
MROUND(Number;Multiple) Function
Returns the number is closer to the
argument “Number” and that is a multiple of the argument “Multiple”. The
argument “Number” contains a numeric value or a reference to a cell containing a
number. Is the number to be used for the approach. The argument “Multiple”
contains a numeric value or a reference to cell containing a number. Indicates
the number of which must be multiple results. For example:
=MROUND(38;5) Returns 40. Note that 40 is multiple of 5, closer to 38..
=MROUND(718;3) Returns 717. In this case, 717 is a multiple of 3, closer to 718.
=MROUND(33;4) Returns 32. As can be seen, 32 is a multiple of 4, closer to 33.