Catalog

How to Use the MROUND Function in Excel (Easiest Ways)

November 10, 2023 1.1K views

Rounding numbers to particular values is something many of us face problems with. But you don’t have to fret anymore, as Excel’s MROUND feature is here to help. However, there is a problem: when a number sits precisely between the two multiples, MROUND goes towards the positive infinity from zero. This gives rise to a question – How can we effectively use the MROUND function in Excel? Read on to know the answer!

What is the MROUND Function in Excel

The MROUND is the MATH and TRIGONOMETRY function in Excel that is used for the conversion of a number to its nearest multiple numbers. This function comes in handy when you want to round a number back to the wanted multiple.

Syntax of MROUND Function

The multiple to be used for rounding is given as the significance argument. Rounding takes place when a number is divided by its significance argument, and the resulting remainder is equal to or greater than half that value.

Additionally, the original number is given back if the number is an exact number already and no rounding takes place.

As far as the significance arguments are concerned, there are two arguments in the MROUND function, including:

  • Number: The value that is to be rounded.

  • Multiple: The multiple to which you intend on rounding the number to,

It is important to note that both of these parameters are required here. Also, these two parameters have to have numerical values.

How to Use the MROUND Function in Excel

To learn how to use the MSROUND function in Excel, let’s look at a few examples:

Evaluating Formula Using F9 Key

To comprehend a big formula, it is essential to understand the different parts of the formula step by step. This is known as debugging or evaluation of the formula.

Here is how to use the MROUND function in Excel with formula multiplication for evaluation:

How to evaluate formula using F9 Key



If you are unable to comprehend the formula, you can also evaluate it by using the F9 key.

You can use the F9 key to immediately debug and evaluate the formula so that you can understand the formula better and work with Excel proficiently. Notably, you can only calculate one part of the formula by substituting the actual formula with the formula’s result while pressing the F9 key.

In the example of the MROUND function in Excel given above, a logical test has been applied, for example, A2>40. Taking into account the logical test, you can analyze the cost. If the cost is >40, the result has to be “costly”; otherwise, the result has to be “cheap.”

This means the IF condition returns “costly” when the logical test is “TRUE.” Similarly, it will return “Cheap” when the logical test is “FALSE.”

In the B2 cell, you can see the result as “Cheap.”

How to evaluate formula using F9 Key


Here, you can see that the bar in the formula only chooses the logical test portion of the formula.

How to evaluate formula using F9 Key


Next, tap the F9 key after choosing the logical test component to see the outcome.

The logical test returns "FALSE" as the A2 cell price value is not >40. Because the logical test returns FALSE, you received the outcome "Cheap."

Then, You have to shift to cell B4, which contains the result "Cheap." Click the F9 key in that cell after choosing the logical test portion.

How to evaluate formula using F9 Key


To view the outcome of the logical test,  click the F9 key.

How to evaluate formula using F9 Key


Here, you can see the answer to the logical test as “True.” You will obtain a similar result in the B4 cell after applying the result as “Costly” for the “TRUE” component because the cost of the A4 cell is >40.

However, cell B6 will return the answer “Cheap” despite the price being 40, as the logical test was done as >40 and not >=40.

Evaluate Formula Using EVALUATE FORMULA Option

Using the built-in Excel function "Evaluate Formula is another method of formula evaluation. You can find this option on the "FORMULA."

How to evaluate formula using EVALUATE FORMULA



Here is how you can use the MROUND function in Excel by using EVALUATE FORMULA option:

Step 1: Click on the formula cell you want to examine after choosing it in order to use this functionality.

How to evaluate formula using EVALUATE FORMULA


Step 2: You will see the window below after clicking this button.

How to evaluate formula using EVALUATE FORMULA


Step 3: Clicking "Evaluate" will now evaluate the part that is highlighted.

How to evaluate formula using EVALUATE FORMULA


Step 4: For the evaluation of the second SUM function, select "Evaluate".

How to evaluate formula using EVALUATE FORMULA


Step 5: Both equations are concurrently chosen at this point. To evaluate, select "Evaluate." This will indicate if the logical test is "TRUE" or "FALSE."

How to evaluate formula using EVALUATE FORMULA


Step 6: Now that you have selected the entire formula, click "Evaluate" for the last time to view the result.

How to evaluate formula using EVALUATE FORMULA


As a result, the outcome you will get is "Not Same," as Jan's total and Feb's total are unequal.

MROUND Examples

Let’s look at some MROUND functions in Excel examples:

  • Basic MROUND usage: You can use the formula =MROUND(123, 10) to round the value 123 to the closest multiple of 10. Given that 120 is the closest multiple of 10, which will get the desired outcome.

  • Rounding to the closest dollar: The formula =MROUND(12.37, 1) can be used to round an amount of $12.37 to the closest dollar. Due to the fact that 12 is the closest complete dollar, it will return the corresponding outcome.

  • Rounding time to the closest quarter-hour: The formula =MROUND(1.783333, 1/4) can be used to round a time value of 1 hour and 47 minutes to the nearest quarter-hour. The MROUND function in Excel for time will give the closest quarter-hour result of 1.75, or 1 hour and 45 minutes.

Best Compatible with Microsoft Excel- WPS Office

In the contemporary digital age, having efficient software programs at hand has become crucial for productivity. Two such software programs are Microsoft Excel and WPS Office. Both of these office suites come with an array of tools to fit the different needs of individuals.

WPS Office Free Download


Taking that into account, it becomes a bit baffling to pick the best out of the two. If you are looking for a free office suite that will cater to all of your needs, WPS Office is your go-to option. Here are a few of the reasons why you should go for WPS Office.

  • Cost


While choosing your office suit, one thing that you always need to take into account is the cost. Many productivity suits are expensive and can be hard to afford, especially for students.

Notably, WPS Office starts at $3.99 per user per month; it provides two subscription plans based on the number of accounts instead of the feature. The basic package starts at $3.99/month per user, which is a great deal for people on a budget.

  • Features

Moreover, you can also get WPS Office for free with limited features.

WPS Office also comes with a selection of tools. Its significant features include WPS Writer, Presentation, and Spreadsheets/. In addition to that, it also comes with a PDF reader.

In terms of fundamental software capabilities, WPS Office is on par with many productivity suits. This makes it the best option if you want an office suite for writing presentations, graphs, or tables.

  • Compatibility

Operating platforms, including Windows, Linux, and Mac, are all supported by WPS Office. It is more adaptable than Office 365 in that you can use it offline as well as online.

Furthermore, WPS Office's compatibility with Microsoft Office file formats, including DOCX, PPT, and XLXS, enables users to work with Word, Excel, and PowerPoint files without a hitch.

  • User-friendly Interface

If you are used to using Microsoft Office, you can switch smoothly to WPS Office thanks to its simple and familiar interface. This makes WPF Office a great free alternative for producing and editing documents, spreadsheets, and presentations with its extensive feature set and user-friendly design.

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

FAQs About MROUND Function in Excel

Q1: What is the difference between the ROUND and MROUND function in EXCEL?

A: ROUND is an equation that rounds a numerical value to the given number of decimal places or multiples of value. In contrast, MROUND down EXCEL is an equation that rounds a numeric value to the closest multiple of a given number.

Q2: How do I round to 2 decimal places in Excel?

A: In Excel, you can use the "ROUND" function to round to two decimal places: =ROUND(A1, 2), where A1 is the cell carrying the number to be rounded.

Q3: How do I round a range of numbers in Excel?

A: Type "=SUM(ROUND(range, num_digits))" into your formula, where "range" is the range of cells to sum and "num digits" is the number of decimal places to round to.

Summary

To sum it all up, the MROUND function in Excel allows users to round numbers to particular multiples, although it can have problems with numbers between multiples. In the meantime, WPS Office, an open-source alternative to Microsoft Excel, provides low-cost plans, a variety of tools, compatibility with multiple platforms, and an easy-to-use interface, which makes it an effective tool for boosting production.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.