MROUND

Rounds a number to the nearest specified multiple to align values with defined increments.

The MROUND function rounds a number to the nearest multiple of a specified value. It adjusts the input number up or down to the closest multiple based on the given significance. This function is commonly used in financial calculations, pricing, and quantity adjustments where values must align with defined increments.

Syntax

MROUND(value, multiple)

Arguments

value - The number to be rounded (Required).

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

Example

MROUND(COLUMN1, 2)

In the example below, the MROUND measure is created using the MROUND function, which rounds the Sum of Quantity values to the nearest specified multiple (2).

Applying MROUND Function