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

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

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

Error.

User does not have sufficient privileges to access this Content