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)

Screen_Shot_2020-12-01_at_10.33.24_AM.png

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

Screen_Shot_2020-12-01_at_10.34.32_AM.png

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