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