MROUND
TheMROUND
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.
 How to use
MROUND
formula?  Examples of using
MROUND
formula MROUND
formula not working? Similar formulas to
MROUND
Usage
Use the 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 nonzero number.
Examples
Here are a few example use cases that explain how to use theMROUND
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.
Related Formulas
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 theplaces
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.
Learn More
You can learn more about the MROUND
Google Sheets function on Google Support.