# MROUND

### Definition of MROUND:

Rounds one number to the nearest integer multiple of another.

### Sample Usage

`MROUND(21,14)`

`MROUND(A2,3)`

### Syntax

`MROUND(value,factor)`

`value`

- The number to round to the nearest integer multiple of another.`factor`

- The number to whose multiples`value`

will be rounded.

### Notes

Both

`value`

and`factor`

may be non-integral.`value`

and`factor`

must have the same sign; that is, they must both be positive or both negative. If either is zero,`MROUND`

will return`0`

.If

`value`

is equally close to two multiples of`factor`

, the multiple with the greater absolute value will be returned.

### See Also

`TRUNC`

: Truncates a number to a certain number of significant digits by omitting less significant digits.

`ROUNDUP`

: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

`ROUNDDOWN`

: Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

`ROUND`

: Rounds a number to a certain number of decimal places according to standard rules.

`INT`

: Rounds a number down to the nearest integer that is less than or equal to it.

`FLOOR`

: Rounds a number down to the nearest integer multiple of specified significance.

`CEILING`

: Rounds a number up to the nearest integer multiple of specified significance.

**Step 1. **To use the MROUND Formula, **start with the Excellentable you would like to edit.**

**Step 2. Then type the MROUND** **formula into the cell you have chosen to display the outcome:**

**Step 3. Fill in the 2 values. **

### By adding the values you would like to calculate, Excellentable generates the outcome: