MROUND Function: Difference between revisions

From Planfix
Jump to: navigation, search
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


Go To