MROUND function in Excel

What is MROUND function in Excel?

The MROUND function is one of the math functions of Excel.

It returns a number rounded to the desired multiple.

We can find this function in Math & trig category of insert function Tab.

How to use MROUND function in excel

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on the fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

insert function tab

4. Select math and trig category

5. Select MROUND function

6. Then select ok

math and trig function  category in excel

7. In the function arguments Tab you will see MROUND function

8. Number section is the value to round.

9. Multiple section is the multiple to which you want to round number.

10. If you enter for example (100,3) result will be 99

MROUND function in excel

11. If you enter (-100,-3) result will be -99

MROUND function in excel

12. You will see results in the formula result section

Things to Remember

  • The argument of this function is number
  • The argument of this function is required and not optional
  • This function is available for all excel versions(2007-2019)

Examples of MROUND function in excel

Example 1:

How to use MROUND function in excel

You can see examples of MROUND function below:

Examples of MROUND function in excel
mround(A2,B2) ----->>>>answer is  123

mround(A3,B3) ----->>>>answer is  124

mround(A4,B4) ----->>>>answer is   0

mround(A5,B5) ----->>>>answer is  -123

mround(A6,B6) ----->>>>answer is  -124

What is the purpose of MROUND function?

It returns a number rounded to the desired multiple.

What is the Return value of MROUND function?

It returns a number.

How many arguments does MROUND function have?

This function has just 1 Argument.

The argument of MROUND function is number.

Number section is the value to round.

Multiple section is the multiple to which you want to round number.

The argument of MROUND function is required and not optional.

MROUND(number) = number

Which version of excel supports MROUND function?

This function is available for all excel versions (2003-2019)

Errors in MROUND function

MROUND related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *