MROUND 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.

You can set a default decimal point for numbers in Excel Options. In the Places box, enter a positive number for digits to the right of the decimal point or a negative number for digits to the left of the …

MROUND 返回一个舍入为所需倍数的数字。 如果数值 number 除以基数的余数大于或等于基数的一半，则函数 MROUND 向远离零的方向舍入。 Number 和 Multiple 参数的符号必须相同。 如果不相 …

MROUND は、目的の倍数に丸められた数値を返します。 数値を倍数で割った剰余が倍数の半分以上である場合は、0 から遠い方の値に丸められます。 数値と倍数の引数には、同じ符号が必要です。 …

MROUND 會傳回四捨五入至所要倍數的數位。 如果 number 除以 multiple 所得的餘數大於或等於 multiple 的二分之一，則 MROUND 會以背於零的方式進位。 Number 和 Multiple 自變數必須有相同 …

These functions aren't available in earlier versions. Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 …

To always round down (toward zero), use the ROUNDDOWN function. To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function. Example Copy the …

This article describes the formula syntax and usage of the CEILING function in Microsoft Excel. Description Returns number rounded up, away from zero, to the nearest multiple of significance.

Hàm MROUND trả về một số được làm tròn đến bội số mong muốn. Hàm MROUND làm tròn lên, hướng ra xa số không, nếu số dư sau khi chia number cho multiple lớn hơn hoặc bằng một nửa giá …

MROUND 會傳回四捨五入至所要倍數的數位。 如果 number 除以 multiple 所得的餘數大於或等於 multiple 的二分之一，則 MROUND 會以背於零的方式進位。 Number 和 Multiple 自變數必須有相同 …