Excel Function Translator Logo
    The Excel Translator

    MROUND

    Math & Trig

    Rounds a number to the nearest specified multiple.

    Translations
    EnglishMROUND
    FrenchARRONDI.AU.MULTIPLE
    SpanishREDOND.MULT
    GermanVRUNDEN
    ItalianARROTONDA.MULTIPLO
    PortugueseMARRED
    DutchAFRONDEN.N.VEELVOUD
    PolishZAOKR.DO.WIELOKR
    RussianОКРУГЛТ
    TurkishKYUVARLA
    CzechZAOKROUHLIT.NA.NÁSOBEK
    HungarianKEREKÍTÉS.TÖBBSZÖRÖS
    SwedishMAVRUNDA
    DanishMAFRUND
    FinnishPYÖRISTÄ.KERRANNAINEN
    Syntax
    MROUND(number, multiple)

    Arguments

    • numberNumber to round
    • multipleMultiple to round to
    Examples
    =MROUND(7,5)
    5

    Rounds to nearest 5

    =MROUND(13,5)
    15

    Rounds up to nearest 5

    =MROUND(1.3,0.5)
    1.5

    Rounds to nearest 0.5

    Tips & Best Practices
    • •Rounds to nearest (up or down)
    • •Different from FLOOR (always down) and CEILING (always up)
    • •Number and multiple must have same sign
    Common Mistakes
    • •Forgetting that MROUND requires the number and multiple arguments to have the same sign - mixing a positive number with a negative multiple (or vice versa) raises a #NUM! error
    • •Expecting MROUND to always round down or up consistently - it actually rounds to the nearest multiple, which could be either up or down depending on which is closer, similar to standard rounding but for arbitrary multiples instead of decimal places
    • •Using MROUND with a multiple of 0, which returns 0 regardless of the number argument, since rounding to the nearest multiple of zero is mathematically only satisfied by zero itself
    Related Functions
    ROUNDRounds to the nearest decimal place rather than the nearest multiple of an arbitrary number like MROUND.
    CEILINGAlways rounds up to the nearest multiple, rather than rounding to whichever multiple is nearest like MROUND.
    FLOORAlways rounds down to the nearest multiple, the opposite consistent direction from CEILING, and a different behavior than MROUND's nearest-multiple approach.
    Frequently Asked Questions

    Why does MROUND return a #NUM! error?

    The number and multiple arguments likely have different signs - a positive number needs a positive multiple, and a negative number needs a negative multiple.

    Does MROUND always round up?

    No, it rounds to whichever multiple is closer, up or down, similar to how standard rounding works for decimal places but applied to any chosen multiple.

    What happens if I use MROUND with a multiple of 0?

    It returns 0, regardless of the number argument, since the only multiple of zero is zero itself.

    Need to translate a formula using MROUND?

    Use our translator to convert your complete formula