EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Maths Function in Excel MROUND in Excel
 

MROUND in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated May 9, 2023

MROUND 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 as to round the supplied number up or down to a mentioned multiple within the formula. This function can be used to round a number according to a multiple. According to the different situations, this will round the number towards 0 or away from 0.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Syntax:

MROUND Syntax

Arguments of MROUND Function:

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

If you look at the process or how it operates among the provided data, the MROUND function will round your number supplied into a perfect multiple up or down to the given multiple. Per the condition, the multiple can select towards 0 or away from 0. You might need clarification about how this can be selected, the criteria to select a multiple greater than the number to be rounded, and what it 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 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 half of the multiple, round the number down.

Suppose 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:

MROUND= (15,6)

You may need clarification about whether the number round into 18 or 12. 18 is the nearest multiple of 6 away from 0, and 12 is also a multiple toward 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 you select as a result? In such a situation, you can go through the two conditions 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 remainder to select the condition.

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

Here the remainder is 3. Check whether the reminder is greater than or equal to 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, round the number up or away from zero.

Example 2: Rounding Times

You can apply the MROUND 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 as “0:05” in the formula. The formula is ‘=MROUND(A2, “0:05”)’. If the result shows, some other values change the format to time as you are 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 the 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 method is effective for applying according to the discounts 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 cells C2 to C7.

MROUND Function on Price 3-7

Things to Remember About MROUND in Excel

  • MROUND function works only with numbers; both arguments should be numbers.
  • #NAME?” will be the error produced if any parameters are not numeric.
  • If signs like positive or negative are used along with any of the parameters, 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, 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

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download MROUND Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download MROUND Excel Template

EDUCBA

डाउनलोड MROUND Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW