MROUND function

MROUND rounds a number to the nearest multiple of a specified value, useful for rounding to standard increments like 5, 10, or 100.

=MROUND(number, multiple)

Generate a MROUND formula

Describe what you need. The generator will reach for MROUND where MROUND is the right tool, and tell you when it is not.

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

How MROUND reads its arguments
numberrequiredmultiplerequiredMROUND →
ArgumentRequiredDescription
numberRequiredThe value to round. Can be positive or negative, but must have the same sign as multiple.
multipleRequiredThe multiple to which number is rounded. Cannot be zero; must have the same sign as number.

Returns

A number rounded to the nearest specified multiple.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Round list prices to nearest $50,000 for market tier analysis

AddressBedsBathsList PriceDays on Market
123 Oak St3248500014
456 Maple Ave4362500021
789 Pine Ln213150008
=MROUND(D2,50000)

Result: 500000

The list price $485,000 is rounded to the nearest $50,000 increment, which is $500,000. This groups similar properties into price tiers for market comparison and competitive analysis.

2. Calculate and round price per bedroom to nearest $10,000

AddressBedsBathsList PriceDays on Market
123 Oak St3248500014
456 Maple Ave4362500021
789 Pine Ln213150008
=MROUND(D2/B2,10000)

Result: 160000

The price-per-bed ($485,000 ÷ 3 = $161,667) is rounded to the nearest $10,000, yielding $160,000. This standardizes affordability metrics across properties with different bedroom counts for fair comparison.

3. Round days on market to nearest 10 for showing frequency scheduling

AddressBedsBathsList PriceDays on Market
123 Oak St3248500014
456 Maple Ave4362500021
789 Pine Ln213150008
=MROUND(E2,10)

Result: 10

The 14 days on market rounds to the nearest 10-day increment, which is 10. This clusters listings into marketing phases: early market (0–10 days), active (10–20 days), or long-listed (20+ days) for staging decisions.

Common errors

Which MROUND error are you seeing?
MROUND returned an error#NUM!
Ensure multiple is not zero and both arguments share the same sign. Use ABS() if needed: =MROUND(ABS(number),ABS(multiple)).
#VALUE!
Verify both arguments resolve to numbers. Remove quotes, use VALUE() to convert text strings, or check for hidden text in cells.
#DIV/0!
Review the formula supplying multiple and eliminate division by zero. Use error handling: =IFERROR(MROUND(number,multiple),"Invalid").
ErrorWhy it happensHow to fix it
#NUM!The multiple argument is zero, or number and multiple have different signs (e.g., positive number with negative multiple).Ensure multiple is not zero and both arguments share the same sign. Use ABS() if needed: =MROUND(ABS(number),ABS(multiple)).
#VALUE!One or both arguments are text, dates stored as text, or other non-numeric values instead of actual numbers.Verify both arguments resolve to numbers. Remove quotes, use VALUE() to convert text strings, or check for hidden text in cells.
#DIV/0!The multiple argument is calculated with a formula that divides by zero, such as =MROUND(A2, 100/0).Review the formula supplying multiple and eliminate division by zero. Use error handling: =IFERROR(MROUND(number,multiple),"Invalid").

Tips and when to use something else

  • MROUND is ideal for rounding prices to standard increments ($5, $10, $50, $100, $1000). Use ROUND instead to round to a fixed number of decimal places.
  • Both number and multiple must have the same sign; MROUND returns #NUM! if they don't. Convert signs with ABS() or manual negation if needed.
  • MROUND uses standard rounding (round half away from zero): MROUND(125, 10) = 130 and MROUND(-125, 10) = -130.
  • Combine MROUND with aggregate functions: =MROUND(SUMIF(range,criteria),multiple) rounds a conditional sum to the nearest increment.

Related functions

ROUNDROUND returns a number rounded to a specified number of decimal places, using standard rounding rules (0.5 rounds up).ROUNDUPRounds a number up to a specified number of decimal places, always rounding away from zero, useful for conservative financial estimates.ROUNDDOWNROUNDDOWN returns a number rounded down toward zero to the specified number of decimal places, useful for inventory and billing calculations.CEILING.MATHCEILING.MATH rounds numbers up to the nearest multiple of a given significance value, useful for conservative cost estimates and price rounding.FLOOR.MATHRounds a number down to the nearest multiple of a specified significance value, commonly used for budget categories and interval-based rounding.

Frequently asked questions

How is MROUND different from ROUND?
ROUND(number, decimals) rounds to a fixed number of decimal places; MROUND(number, multiple) rounds to the nearest multiple. Use MROUND for standard increments ($10, $50, $100), and ROUND for decimal precision (cents, pennies).
Can MROUND work with decimal multiples?
Yes. MROUND(3.7, 0.5) = 3.5 and MROUND(100.35, 0.1) = 100.4 are both valid. This is useful for rounding prices to quarters ($0.25) or other fractional increments.
What happens when the number is exactly halfway between two multiples?
MROUND uses "round half away from zero," so MROUND(125, 10) = 130 and MROUND(-125, 10) = -130. Positive halfway values round up; negative ones round down.
When should I use MROUND instead of CEILING, FLOOR, or other rounding functions?
Use MROUND for "round to nearest" behavior with custom increments. Use CEILING.MATH or FLOOR.MATH to always round up or down. Use INT or TRUNC to strip decimals without rounding. Each serves a different rounding strategy.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17