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

`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`: The ROUNDDOWN function rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

`ROUND`: The ROUND function 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`: The FLOOR function rounds a number down to the nearest integer multiple of specified significance.

`CEILING`: The CEILING function rounds a number up to the nearest integer multiple of specified significance.