MRound

Rounds the number down to the closest multiple of the specified number Category: math Syntax:

MRound([number], multiple)

Returns: Number Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`number`	`number or column`	✓ Yes	The number to be rounded
`multiple`	`number`	✗ No	The multiple to round the number to

Allowed Column Types for number: INT, FLOAT, DECIMAL

MRound([Number])

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

MRound([Cost], 5)

Rounds each value in the Cost column to the nearest multiple of 5

MRound(23, 5)

Returns 25 Result: 25

MRound(27, 5)

Returns 25 Result: 25

MRound(23, -5)

Returns 25 (negative factor sign is ignored) Result: 25

Last modified on March 6, 2026