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.