MROUND Function

From PlanFix
Jump to: navigation, search

The function MROUND returns a number rounded to the desired multiple.


Format:

MROUND(number;multiple)


Examples:

MROUND(10;3) - rounds the number 10 to the nearest multiple of 3. Result = 9

MROUND(1.3;0.2) - rounds the number 1.3 to the nearest multiple of 0.2. Result = 1.4


Go To