MROUND Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
{{#seo: | |||
|title=MROUND Function | |||
|titlemode=append | |||
|keywords=planfix, Function, MROUND, reports | |||
|description=MROUND Function | |||
}} | |||
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 13: | ||
''Examples:'' | ''Examples:'' | ||
Latest revision as of 07:55, 10 May 2024
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