Skip to content
Excel

MROUND function in Excel

Returns a number rounded to the desired multiple

=MROUND(number, multiple)

MROUND syntax and parameters

Two arguments, two required.

  • numbernumberRequired

    The value to round.

  • multiplenumberRequired

    The multiple to which you want to round number.

MROUND examples

Formulas you'll actually reuse.

  1. To the nearest 5 cents — cash rounding:

    =MROUND(B2, 0.05)

    Result23.8

  2. Minutes rounded to the nearest quarter hour:

    =MROUND(B2, 15)

    Result45

MROUND in Google Sheets

Same name — your formula ports as-is.

Try MROUND in the playground

Edit the example — nothing to install.

Preloaded with the MROUND formula from Example 1 — change anything and watch it respond.

Loading the editor…

MROUND errors

What they mean — and the fixes.

  • #NUM!

    The number and the multiple have different signs — both must be positive or both negative.

Related functions

More ways Excel gets this done.