MROUND
Rounds a number to the desired multiple.
=MROUND(number, multiple)This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.
What the function does
Overview
Rounds a number to the desired multiple.
MROUND returns a number rounded to the nearest specified multiple. Unlike standard rounding functions that target decimal places, MROUND finds the closest neighbor based on the provided interval. If the remainder of dividing the number by the multiple is equal to or greater than half the value of the multiple, the function rounds away from zero. A critical technical constraint is that the 'number' and 'multiple' arguments must share the same arithmetic sign (both positive or both negative); providing mixed signs results in a #NUM! error. This is a best-practice tool for financial tasks like rounding to the nearest nickel (0.05) or for logistical operations like rounding order quantities to the nearest pallet or case size. It is also the standard method for rounding timestamps to specific increments, such as 15 or 30-minute billing blocks.
Quick reference
Syntax
=MROUND(number, multiple)Inputs
Arguments
Example: A2
Example: 5
Formula patterns
Examples
Rounding retail prices to the nearest 0.05
=MROUND(A2, 0.05)Rounding work timestamps to 15-minute increments
=MROUND(A2, B2)Adjusting negative debt values to the nearest hundred
=MROUND(A2, -100)Avoid these issues
Common Errors
#NUM!
Cause: The number and the multiple arguments have different signs (e.g., one is positive and one is negative).
Fix: Ensure both arguments are either positive or negative. If the multiple must always match the sign of the number, use =MROUND(A2, SIGN(A2)*0.5).
#VALUE!
Cause: One or both of the arguments provided are text strings or non-numeric values.
Fix: Clean the source data to remove non-numeric characters and ensure the referenced cells are formatted as numbers or decimals.
Platform support
Compatibility
Source: Microsoft Support
Common questions
Frequently Asked Questions
Rounds a number to the desired multiple.
number: Value to round multiple: Multiple to round to
#NUM!: Ensure both arguments are either positive or negative. If the multiple must always match the sign of the number, use =MROUND(A2, SIGN(A2)*0.5). #VALUE!: Clean the source data to remove non-numeric characters and ensure the referenced cells are formatted as numbers or decimals.