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.

Value	Rounding multiple	Result
0.4	1	0
0.5	1	0
0.6	1	1
8	3	9
9	3	9
10	3	9
11	3	12
12	3	12
13	3	12
1234	100	1200
1250	100	1200
1251	100	1300
1299	100	1300

Browser not supported