Returns a number rounded to the nearest specified multiple.
الصيغة
MROUND(number, multiple)المعاملات
numberمطلوب
The value you want to round.
multipleمطلوب
The multiple to which you want to round the number.
MROUND rounds a number up or down to the nearest multiple of the provided argument. If the remainder of dividing the number by the multiple is greater than or equal to half the value of the multiple, the function rounds away from zero.
=MROUND(10, 3)→910 is rounded to the nearest multiple of 3, which is 9.
=MROUND(11, 3)→1211 is rounded to the nearest multiple of 3, which is 12.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =MROUND(number, multiple) and replace the arguments with your desired values or cell references.
MROUND will return a #NUM! error if the number and multiple have different signs.