MROUND Function – Google Sheets

The MROUND function in Google Sheets rounds a number to the nearest multiple of a specified factor. This rounding can be helpful in various scenarios, such as rounding prices to the nearest nickel or rounding time to the nearest half-hour.

Rounding occurs when the remainder from dividing the value by factor is greater than or equal to half the value of the factor. If the value is already an exact multiple, no rounding occurs, and Google Sheets returns the original value.


=MROUND(value, factor)

value – The number for the function to round

factor – The multiple to round with

Similar Functions

Several functions deal with rounding. Choose the most appropriate for your use.

  • CEILING – Rounds a number up to the nearest integer multiple of specified significance
  • INT – Rounds a number down to the nearest integer
  • FLOOR – Rounds a number down to the nearest integer multiple of specified significance
  • MROUND – Rounds one number to the nearest integer multiple of another
  • ROUND – Round a number to a specified number of decimal places using standard rounding
  • ROUNDDOWN – Round a number down to a specified number of places
  • ROUNDUP – Round a number up to a specified number of places
  • TRUNC: Truncates a number to a certain number of significant digits by omitting less significant digits

Insert Math Symbols (Add-On)

Web banner showing math symbols from the Insert Special Characters Add-On
Explain Your Formulas with Symbols

Possible Errors

#NUM! – The value and the factor are different signs. Make both positive or negative.


You can use MROUND in many different ways. Let’s take a look at a few, starting with rounding currency.

Example 1 – Round to the Nearest Nickel

Sometimes it looks better to present a price rounded to the nearest nickel. Let’s look at how to do that.

Rounding prices to the nearest nickel with the MROUND function
Rounding to the Nearest Nickel

The formula used in cell C2: =MROUND(A2,B2)

We use the MROUND function to divide the Original Price by the factor of $0.05. Since the function uses standard rounding (instead of rounding up or down), it rounds $1.21 down to $1.20 in row 2 and rounds $1.23 up to $1.25 in row 3. Google Sheets does not round the last value in column A because it is already a multiple of $0.05.

Example 2 – Round to the Nearest Half Hour

Next, let’s round some time values. It is common to refer to a time as a rounded value. In this example, we’ll round values to the closest half-hour.

The MROUND function rounding a time to the nearest half hour
Rounding to the Nearest Half Hour

⚠️ You can enter a half hour as “0:30” or “0:30:00“. Either way, you’ll need to use custom formatting to remove the seconds, like in the example above in column B.

Rows 2 and 3 both round to 1:30 following the standard rounding rules of rounding to the nearest value. As 1:45 PM is halfway between 1:30 PM and 2:00 PM, the MROUND function rounds it up to 2:00 PM.

Example 3 – Round With Different Factors

Up to this point, we have been changing the value. Now let’s look at changing the factor. We’ll use positive and negative factors to see the differences.

The MROUND function rounding positive and negative numbers with different factors
Rounding Using Different Factors

You can see that negatives and positives move towards the same absolute values. Each output in column C is the opposite sign when the inputs flip their signs.

Live Example in Sheets

Make a copy of this spreadsheet to get the examples in your own Google Sheet.

Leave a Comment