# MRound

Rounds the input number to the closest multiple of the given factor.

## Usage

MRound(number, [factor])

**number** (required) The number to be rounded.

**factor** [optional] The multiple to which the number will be rounded. The positive or negative sign of the factor is not considered. This value cannot be 0. The default value is 1.

## Examples

(1) Rounds the Number column by a factor of 1, since no argument is passed. This is equivalent to the result of the factor of (-1).

MRound([Number])

(2) Rounds the value for each row in the input column to a multiple of 50. The positive or negative sign of the factor (-50) is not considered. As such, they return the same result.

`MRound([Cost], 50)`

(3) Returns 500.

MRound(-456, 100)

## See Also

Round - Rounds the input number to the specified number of digits.

Ceiling - Rounds the input number up to the closest multiple of equal or greater value.

Floor - Rounds the input number up to the closest multiple of equal or lesser value.