MROUND

The MROUND function rounds a number to the nearest multiple of a specified value.

Syntax

mround(value, multiple)

Arguments

value - Required. The number to be rounded.

multiple - Optional. The multiple to which you want to round.

Example

MROUND(COLUMN1, 2)

Returns the round of COLUMN1 to the nearest multiple of 2.