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.

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

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.

The ROUND function rounds a number containing a fraction as follows: If the fractional part is 0.5 or greater, the number is rounded up. If the fractional part is less than 0.5, the number is rounded down.

The ROUND function rounds a number containing a fraction as follows: If the fractional part is 0.5 or greater, the number is rounded up. If the fractional part is less than 0.5, the number is rounded down.

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

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

MROUND mengembalikan angka yang dibulatkan ke kelipatan yang diinginkan. MROUND membulatkan ke atas, menjauhi nol, jika sisa angka pembagi kelipatan lebih besar dari atau sama …

Round a number to the decimal places you want by using formatting and how to use the ROUND function in a formula to round to the nearest major unit such as thousands, hundreds, tens, or ones.