MROUND Function: Difference between revisions
From Planfix
(Created page with "== Go To == * Standard operators and Planfix functions *Calculated fields *Reports") |
No edit summary |
||
| (2 intermediate revisions 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. | |||
''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 == | == Go To == | ||
*[[Standard functions | Standard operators and Planfix functions]] | *[[Standard functions | Standard operators and Planfix functions]] | ||
*[[Calculated fields]] | *[[Calculated fields]] | ||
*[[Reports]] | *[[Reports]] | ||
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