EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel MROUND in Excel
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

MROUND in Excel

By Madhuri ThakurMadhuri Thakur

MROUND in Excel

MROUND in Excel (Table of Contents)

  • What is MROUND in Excel?
  • How to Apply the MROUND Function in Excel?

What is MROUND in Excel?

MROUND is an Excel function categorized under math & trigonometric function in Excel. Commonly this function is used with numeric values. The function operates in such a way to round the supplied number up or down to a mentioned multiple within the formula. If you want to round a number according to a multiple, this function can be used. This will round the number towards 0 or away from 0 according to the different situations.

Syntax:

MROUND Syntax

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Arguments of MROUND Function:

  • Number: The numerical value that you want to convert or want to round.
  • Multiple: The multiple to which you round the specified number.

If you look at the process or how it is operating among the provided data, the MROUND function will round your number supplied into a perfect multiple up or down to the given multiple. As per the condition, the multiple can select towards 0 or away from 0. You might get confused about how this can be selected or what could be the criteria to select a multiple greater than the number to be rounded and what will be to select a number less than the given number. For this, you can refer to the two conditions explained below. The given number will fall in any of the below conditions.

  1. Divide the number you want to round with the multiple. If the remainder is greater than or equal to the half of the multiple, then round the number up.
  2. Divide the number you want to round with the multiple. If the remainder is less than or equal to the half of the multiple, then round the number down.

If the formula applied is MROUND= (7,4). This rounds the number 7 into the nearest multiple of 4. The result will be 8. For more clarification, you can go through the detailed examples.

How to Apply MROUND Function in Excel?

Let’s understand how to apply the MROUND in Excel with some examples.

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

Example #1 – Rounding Up Multiple of a Number

Before getting into complicated calculations, let’s learn the logic of the MROUND function. For example, you have given the number 15 and want to round it into the multiple of 6. So the formula applied will be:

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,813 ratings)

MROUND= (15,6)

You may be getting into confusion like whether the number round into 18 or 12. 18 is the nearest multiple of 6 away from 0 and 12 is also a multiple towards 0. Both are two nearest multiple up (away from 0) and down (towards 0) to the number you want to round. So which number could select as a result? In such a situation, you can go through the two different conditions given below and select the appropriate condition for the data given.

Divide 15 the number you want to round with the multiple 6. It depends on the value of the reminder to select the condition.

  1. If the remainder is greater than or equal to half of the multiple, then round the number which is away from zero.
  2. If the remainder is less than the multiple, then round the number, which is towards zero.

Here the remainder is 3. Check whether the reminder is greater than or equal to the half of the multiple. Multiple is 6, and half of the multiple is 3; in this situation, you can go ahead with the first condition that is round the number up or away from zero.

Example 2: Rounding Times

You can apply the MROUND within time to the nearest 5 and 10 minutes. The time is provided and let’s apply the formula to it.

MROUND in excel 2-1

  • The time is given in (hh: mm: ss AM/PM) format, so the minute is mentioned “0:05” in the formula. The formula is ‘=MROUND(A2, “0:05”)’ if the result shows some other values change the format into time as you given the time format.

MROUND in excel 2-2

  • After applying the formula, the answer is shown below.

MROUND in excel 2-3

  • Drag the same formula in cell B2 to B9.

MROUND in excel 2-4

  • The results are rounded accordingly, and the result is calculated depending on the same rules of the reminder value.

Round to 5 min - 1

  • In the same way, 10 minutes is rounded, and the formula is ‘=MROUND(B2, “0:10”)’.

Round to 5 min - 2

  • After applying the formula, the answer is shown below.

Round to 5 min - 3

  • We will be applying the same formula to entire cells, and the final result is as shown:

Round to 5 min - 4

Example #3 – MROUND Function on Price

Through this example, you can learn how the MROUND function can be used to round the fraction of price or amount while making billing towards a large amount. This is used to provide discounts on the fraction of the amount of rounding the amount into a perfect figure.

Example 3

  • In a big deal of amounts, to avoid the small sum of prices, you can use this MROUND function. This is an effective method to apply according to the discounts that you provide or a fraction of the amount you want to neglect. The formula applied is ‘=MROUND(A2,0.05).’

MROUND Function on Price 3-2

  • After applying the formula, the answer is shown below.

MROUND Function on Price 3-3

  • Drag the same formula in cell B2 to B7.

MROUND Function on Price 3-4

  • Apply the below formula in cell C2.

MROUND Function on Price 3-5

  • After applying the formula, the answer is shown below.

MROUND Function on Price 3-6

  • Drag the same formula in cell C2 to C7.

MROUND Function on Price 3-7

Things to Remember About MROUND in Excel

  • MROUND function works only with numbers; both the arguments should be numbers.
  • #NAME?” will be the error produced if any one of the parameters is not numeric.
  • If any signs like positive negative are used along with any one of the parameters or both, it will show an error “#NUM!”.

Recommended Articles

This is a guide to MROUND in Excel. Here we discuss how to apply MROUND in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. ROUND Excel Function
  2. Excel ROUNDUP Function
  3. ROUND Formula in Excel
  4. Excel ROUNDDOWN Function
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download MROUND Excel Template

EDUCBA

Download MROUND Excel Template

EDUCBA

डाउनलोड MROUND Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more