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.

Round off the Quanity to the nearest multiple of 2