MROUND Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
The function MROUND returns a number rounded to the desired multiple. | The function MROUND returns a number rounded to the desired multiple. | ||
''Format:'' | ''Format:'' | ||
| Line 6: | Line 7: | ||
''Examples:'' | ''Examples:'' | ||
Revision as of 05:50, 11 December 2019
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