MROUND Function

From Planfix
Revision as of 05:50, 11 December 2019 by SliZzzZ (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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