# 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) Returns 3

MRound(3.2, 1)

(2) Returns -4.

`MRound(-3.2, 1)`

(3) Rounds the value for each row in the input column to a multiple of 50.

MRound([Cost], 50)

(4) 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, examples (3) and (4) return the same result.

MRound([Cost], -50)

(5) 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.