Page tree
Skip to end of metadata
Go to start of metadata

Syntax

MROUND(<number>;<number>) 

Description

Returns a number rounded to the desired multiple.

MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.

Example

=MROUND(19.4445; 2) returns 20 because 19.4445 is closer to 20 than it is to 18
=MROUND(0.7651; 1) returns 1 because 0.7651 is closer to 1 than it is to 0. 

ValueRounding multipleResult
0.410
0.510
0.611
839
939
1039
11312
12312
13312
12341001200
12501001200
12511001300
12991001300
  • No labels