WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » MROUND in Excel

MROUND in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

MROUND Function in Excel

MROUND is the MATH & TRIGNOMETRY function in excel and is used to convert the number to the nearest multiple numbers of the given number. For example, =MROUND(50,7) will convert the number 50 to 49 because number 7 nearest multiple 49, in this case, it has rounded down to the nearest value. Similarly, if the formula is =MROUND(53,7) then this will convert the number 53 to 56 because multiple number 7 nearest number for number 53 is 56, in this, it has rounded up to nearest multiple values odd number 7.

Syntax

MROUND Formula

  • Number: What is the number we are trying to convert to?
  • Multiple: The multiple numbers we are trying to round the Number.

Here both the parameters are mandatory, and both the parameters should include numerical values. We will see some of the examples of MROUND function practically.

Examples to use MRound Function in Excel

You can download this MROUND Function Excel Template here – MROUND Function Excel Template

Example #1

MROUND excel function rounds the number to the nearest multiple of the provided number. You must be thinking how does excel know whether to round up or round down, it depends on the result of the division.

For an example 16 / 3 = 5.33333, here decimal value is less than 0.5 so result of nearest multiple value of number 3 is 5, so 3 * 5 = 15. Here excel rounds down the value if the decimal value is less than 0.5.

Similarly look at this equation 20 / 3 = 6.66667, in this equation decimal value is greater than 0.5 so excel rounds up the result to 7, so 3 * 7 = 21.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

So for this example, consider the below data.

MROUND in Excel Example 1

  • Open excel MROUND function in cell C2 first.

MROUND in Excel Example 1-1

  • Select the Number argument as cell A2 value.

MROUND in Excel Example 1-2

  • The second argument Multiple is cell B2 value.

Example 1-3

  • Hit the enter key. Copy and paste the formula to other cells to get the result.

Example 1-4

We got the result in all the cells. Let’s look at each example individually now.

In the first cell, the equation reads 15/8 = 1.875; since the decimal value is >= 0.5, excel rounds up the number to the nearest integer value is 2. So here, multiple numbers are 8, and the resulting number is 2, so 8 * 2 = 16.

Look at the second equal 17/5 = 3.4, here decimal is less than 0.5, so excel this time rounds down the number to 3, and the result is 5 * 3 = 15.

Like this excel, MROUND function rounds down or rounds up the number to the nearest integer value of multiple numbers.

Example #2

We have seen how the MROUND function works; now, we will see how we can apply the same to round up or down the time to the nearest multiple values.

Example 2

From the above timetable, we will convert the time to the nearest 45 minute time intervals. Below is the formula.

Example 2-1

In this example, I have supplied the multiple values as “0:45”; this will be automatically converted to the nearest number “0.03125”. So the number “0.03125” is equal to 45 minutes when we apply the time format to this number in excel.

Things to Remember

  • Both the parameters should be numbers.
  • If anyone parameter is not numeric, then we will get the “#NAME?” error value.
  • Both the parameters should have the same signs, either positive or negative if both signs are supplied in a single formula, then we will get the “#NUM!” error value.

Recommended Articles

This has been a guide to MROUND Function in Excel. Here we learn how to use MROUND Function in Excel along with examples and a downloadable template. You may learn more about excel from the following articles –

  • Excel Evaluate Formula
  • ROUND Function in Excel
  • ABS Function in Excel
  • INT Function in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download MROUND Function Excel Template

Coursera IPO Financial Model & Valuation Free Download