MRound

Syntax

MRound(Value, Precision)

Value. Rounded value.

Precision. The multiple, to which you want to round.

NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.

It returns a number rounded with desired precision.

A number is rounded if the precision division remainder is greater or equal to the half of the precision.

Formula	Result	Description
=MRound(4.65,0.1)	4,7	It rounds the 4.65 number to the nearest number divisible by 0.1.
=MRound(B6, C6)	-27,0000	It rounds the number from the B6 cell to the nearest number divisible by the value from the C6 cell. The B6 cell contains the number -26.3. The C6 cell contains -3.