# MROUND

The `MROUND` function rounds a number to the nearest multiple of a specified factor. It is commonly used when dealing with financial data, such as currency or interest rate calculations.

## Usage

Use the `MROUND` formula with the syntax shown below, it has 2 required parameters:

Parameters:
1. value (required):
The number to be rounded to the nearest multiple of the factor.
2. factor (required):
The factor to which the number should be rounded. Must be a non-zero number.

## Examples

Here are a few example use cases that explain how to use the `MROUND` formula in Google Sheets.

### Rounding to the nearest 100

Suppose you have a dataset of numbers that you want to round to the nearest 100. You can use the `MROUND` function to accomplish this. For example, if the value is 153, and the factor is 100, the result will be 200.

### Rounding to the nearest 0.5

Sometimes you may need to round a number to the nearest half, such as when dealing with measurements. You can use the `MROUND` function to achieve this. For example, if the value is 1.3, and the factor is 0.5, the result will be 1.5.

### Rounding down to the nearest 10

You can also use the `MROUND` function to round down to the nearest multiple of a factor. For example, if the value is 38, and the factor is 10, the result will be 30.

## Common Mistakes

`MROUND` not working? Here are some common mistakes people make when using the `MROUND` Google Sheets Formula:

### Incorrect number of arguments

One of the most common mistakes is providing the wrong number of arguments to the MROUND formula. Make sure you have exactly two arguments: the value you want to round and the factor to which you want to round.

### Incorrect argument type

Another common mistake is providing an argument of the wrong data type to the MROUND formula. Make sure both arguments are numeric values.

### Using a negative factor

If you use a negative factor in the MROUND formula, the result may not be what you expect. If you want to round to the nearest 10, for example, use a factor of 10 instead of -10.

### Rounding to an odd factor

If you round to an odd factor with the MROUND formula, the result may not be what you expect. If you want to round to the nearest 5, for example, use a factor of 2.5 instead of 5.

### Unexpected rounding behavior

Be aware that the MROUND formula uses the round half away from zero method, which means that values exactly halfway between two multiples of the factor will be rounded up to the nearest multiple. This can lead to unexpected rounding behavior in some cases.

The following functions are similar to `MROUND` or are often used with it in a formula:

• `ROUND`

The `ROUND` formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If the `places` parameter is not specified, the formula rounds to the nearest integer.

• `CEILING`

The `CEILING` function returns a number rounded up to the nearest multiple of a specified factor. It is commonly used to round up prices to the nearest dollar or to adjust numbers to fit into specific increments.

• `FLOOR`

The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value.

You can learn more about the `MROUND` Google Sheets function on Google Support.