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 round.
multiple: The multiple to which the number is rounded.
Return value
Returns the number rounded to the nearest specified multiple.
Example
MROUND(PlannedUnits,5)
In the example below, the Rounded Planned Units measure is created using the MROUND function, which rounds the Planned Units values to the nearest multiple of 5.
