Spread Formula Reference
Formula Functions / Functions M to Q / MROUND
In This Topic
    MROUND
    In This Topic

    This function returns a number rounded to the desired multiple.

    Syntax

    MROUND(number,multiple)

    Arguments

    This function has these arguments:

    Argument Description
    number Numeric value to round
    multiple Numeric value representing the rounded result

    Remarks

    This function rounds to the nearest multiple (either up or down). For even numbers where there may be two choices (one rounding up and one rounding down), the result is the number farther from zero. For example, MROUND(18,4) returns 20 even though 16 is as near since 20 is farther from zero. For MROUND(-18,-4) returns -20 since that value is farther from zero.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    MROUND(B14,3)

    MROUND(R14C2,5)

    MROUND(100,8) gives the result 104

    MROUND (11,8) gives the result 8

    MROUND (12,8) gives the result 16

    MROUND (13,8) gives the result 16

    MROUND (-12,-8) gives the result -16

    MROUND (50,8) gives the result 48

    MROUND (-50,-8) gives the result -48

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ROUND | Math and Trigonometry Functions