MROUNDfunction 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.
- How to use
- Examples of using
MROUNDformula not working?
- Similar formulas to
MROUND formula with the syntax shown below, it has 2 required parameters:
- value (required):
The number to be rounded to the nearest multiple of the factor.
- factor (required):
The factor to which the number should be rounded. Must be a non-zero number.
ExamplesHere are a few example use cases that explain how to use the
MROUNDformula 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.
MROUNDnot working? Here are some common mistakes people make when using the
MROUNDGoogle 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:
ROUNDformula 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
placesparameter is not specified, the formula rounds to the nearest integer.
CEILINGfunction 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.
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.