How to Use the MROUND Excel Formula: Functions, Examples, and Writing Steps
Home >> Excel Tutorials from Compute Expert >> Excel Formulas List >> How to Use the MROUND Excel Formula: Functions, Examples, and Writing Steps
In this tutorial, you will learn how to use the MROUND excel formula completely.
When working with numbers in excel, we might sometimes want to round our number to a certain multiple. If we use MROUND to help us with the rounding process, we can get our rounding result easily and fast.
Want to know more about this MROUND formula and master the way to use it in excel? Read this tutorial until its last part!
Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more
Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!
Table of Contents:
- What is the MROUND formula in excel?
- MROUND function in excel
- MROUND result
- Excel version from which we can start using MROUND
- The way to write it and its inputs
- Example of its usage and result
- Writing steps
- MROUND not working/gives an error? Possible reasons & solutions
- MROUND to round date
- MROUND to round time
- Exercise
- Additional note
What is the MROUND Formula in Excel?
MROUND is an excel formula that helps you to round your number to a certain multiple.MROUND Function in Excel
You can use MROUND to get the multiple rounding result of your number.MROUND Result
The MROUND result is the number that is the multiple rounding result of your number.Excel Version from Which We Can Start Using MROUND
You can use MROUND in excel since excel 2003.The Way to Write It and Its Inputs
Here is the general writing form of MROUND in excel.
= MROUND ( number_to_round , multiple )
And here is a bit explanation of the inputs you need to give when you write MROUND
- number_to_round = the number you want to round to a certain multiple
- multiple = the multiple you want to round your number to
Example of Its Usage and Result
Here is an implementation example of MROUND in excel.
As you can see in the example, it is quite easy to use MROUND in excel. Just input the number you want to round and its multiple reference, press enter, and you will immediately get your result!
MROUND can round your number up or down depending on which one is closer to the multiple.
Writing Steps
After we have discussed the MROUND writing form, inputs, and implementation example, now let’s discuss its writing steps. As MROUND only needs two simple inputs, these writing steps should be easy to understand.-
Type an equal sign ( = ) in the cell where you want to put your MROUND result
-
Type MROUND (can be with large and small letters) and an open bracket sign after =
-
Input the number you want to round to a certain multiple. Then, type comma sign ( , )
-
Input the multiple you want to round your number into
-
Type a close bracket sign
- Type Enter
-
Done!
MROUND Not Working/Gives an Error? Possible Reasons & Solutions
Your MROUND gives you a wrong result or an error? There are several things that can cause that to happen. The following will give you probably the most possible reasons and their solution.- Reason: You input a positive number/multiple and a negative multiple/number to your MROUND
Solution: MROUND will give you an error if you input a number and a multiple with a different positive/negative affiliation. Change your inputs into all positive or all negative - Reason: You input your number and multiple in the wrong order
Solution: If you identify this mistake, reverse the order of your inputs immediately - Reason: You use MROUND to round decimals
Solution: Some people may mistake MROUND as an excel formula they can use to round decimals. However, MROUND rounds a number to a multiple instead. Use ROUND if you want to round the decimals in your number
Hope those points can make you get your rounding result right in excel!
MROUND to Round Date
By using MROUND, you can also round your date data in excel. MROUND will round the date you input into it to a certain number of days multiple.Here is the general writing form of MROUND when you use it to round date in excel.
= MROUND ( date_to_round , number_of_days_multiple )
And here is its implementation example.
MROUND to Round Time
You can also round your time data with MROUND. For this, you should input your multiple in the form of time too to get the result you want easier.Here is the general writing form of MROUND when we use it to round time.
= MROUND ( time_to_round , time_multiple )
And here is its implementation example.
Exercise
After you understand how to use MROUND in excel completely, practice your understanding by doing the exercise below!Download the exercise file and answer all of the questions. Download the answer key file later when you want to check all of your answers. Or probably if you are confused when you want to answer the questions.
Link to the exercise file:
Download here
Questions
- Round the number in question 1 column to the nearest multiple of 100!
- Round the number in question 2 column to the nearest multiple of 7!
- Round the number in question 3 column to the nearest multiple of 250!
Link to the answer key file:
Download here
Additional Note
Date and time are also numbers in excel (their real form is a number. We just display them differently in comparison to standard numbers). That is why you can round them with MROUND too.Related tutorials you should learn from:
