## 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

- Click on an
**empty**cell (like F5 )

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

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

4. Select **math and trig** category

5. Select **MROUND** function

6. Then select **ok**

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**

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

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:

**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?

**MROUND**

It returns a number **rounded **to the desired multiple.

## What is the Return value of **MROUND** function?

**MROUND**

It returns a number.

## How many arguments does **MROUND** function have?

**MROUND**

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?

**MROUND**

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

## Errors in **MROUND** function

**MROUND**

**MROUND related functions :**

- CEILING function
- FLOOR function
- ROUND function
- ROUNDDOWN function
- ROUNDUP function
- MROUND function
- INT function
- TRUNC function