What is the syntax for MROUND in Excel?

The syntax for MROUND is: =MROUND(number, multiple)

What is MROUND used for in Excel?

MROUND rounds numbers to the nearest multiple you specify. Common uses: rounding time to 15-minute intervals (=MROUND(A1,"0:15")), prices to nearest $0.05, or quantities to pack sizes like dozens.

What is the difference between MROUND, CEILING, and FLOOR?

MROUND rounds to nearest multiple (up or down). CEILING always rounds up to the next multiple. FLOOR always rounds down. For 7 with multiple 5: MROUND=5, CEILING=10, FLOOR=5.

Why do I get #NUM! error with MROUND?

MROUND returns #NUM! when the number and multiple have different signs (one positive, one negative). Both arguments must be positive or both negative. Use ABS() if needed: =MROUND(ABS(A1), 5).

Math & Trig

MROUND Function in Excel

Rounds a number to the nearest specified multiple.

Syntax

=MROUND(number, multiple)

Arguments

number (required): The value to round
multiple (required): The multiple to round to

Examples

=MROUND(10, 3) - Round to nearest 3 - Result: 9
=MROUND(1.3, 0.2) - Round to nearest 0.2 - Result: 1.4

MROUND in reporting workflows

Use absolute references when copying formulas across rows.
For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

#NUM! if signs don't match

Use cases

Time rounding
Pricing to nearest unit
Quantity rounding

Frequently asked questions

What is MROUND used for in Excel? MROUND rounds numbers to the nearest multiple you specify. Common uses: rounding time to 15-minute intervals (=MROUND(A1,"0:15")), prices to nearest $0.05, or quantities to pack sizes like dozens.
What is the difference between MROUND, CEILING, and FLOOR? MROUND rounds to nearest multiple (up or down). CEILING always rounds up to the next multiple. FLOOR always rounds down. For 7 with multiple 5: MROUND=5, CEILING=10, FLOOR=5.
Why do I get #NUM! error with MROUND? MROUND returns #NUM! when the number and multiple have different signs (one positive, one negative). Both arguments must be positive or both negative. Use ABS() if needed: =MROUND(ABS(A1), 5).

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.