Earn your certification as a Financial Modeling & Valuation Analyst (FMVA)™. Register today!

MROUND Function

Returns a number rounded to a specified multiple

What is the MROUND Function?

The MROUND function is categorized under Math and Trigonometry functions. The function will return a number rounded to a multiple given by the user. MROUND will always round up away from zero.

As a financial analyst, the MROUND function helps round a number and eliminate the least significant digits, making it simpler but keeping close to the original value.

 

Formula

=MROUND(number, multiple)

 

The MROUND function uses the following arguments:

  1. Number (required argument) – It is the number that needs to be rounded.
  2. Multiple (required argument) – It is the multiple to which we want to round a number.

 

How to use the MROUND Function in Excel?

To understand the uses of the MROUND function, let’s consider a few examples:

 

Example 1

Suppose we are given the following data:

 

MROUND Function

The results in MS Excel are shown below:

 

MROUND Function - Example 1

 

Example 2

Let’s see how the MROUND function can be used to get a time rounded up to the nearest 30-minute interval. Suppose we are given the data below:

 

MROUND Function - Example 2

 

The formula used is shown below:

 

MROUND Function - Example 2a

 

We get the result below:

 

MROUND Function - Example 2b

 

When we supply “0:30” as the multiple, Excel will internally convert 0:30 into 0.0208333333333333, which is the decimal value that represents 30 minutes.

We can also express 30 minutes in a formula using the formula =30/(60*24).

Alternatively, depending on the requirements, we can use the formula to round to different time intervals such as the nearest 15 minutes or 1 hour.

 

Few notes about the MROUND Function 

  1. MROUND rounds up away from zero.
  2. The number and multiple arguments must be of the same sign.
  3. #NUM! error – Occurs when the number and multiple arguments are not of the same sign.

 

Click here to download the sample Excel file

 

Additional resources

Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

Free Excel Tutorial

To master the art of Excel, check out CFI's FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.  

Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!