# 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.