ROUND

根據標準規則將指定數字四捨五入到特定的小數位數。

使用範本

ROUND(99.44,1)

ROUND(A2)

語法

ROUND(value,places)

• 值 - The value to round to 位數 位數

• 位數 - [ OPTIONAL - 0 by default ] - The number of decimal places to which to round.

  • 位數 may be negative, in which case 值 is rounded at the specified number of digits to the left of the decimal point.

附註

• Standard rules indicate that when rounding to a particular place, the next most significant digit (the digit to the right) is considered. If this digit is greater than or equal to 5, the digit is rounded up, otherwise it is rounded down. This occurs irrespective of sign; that is, 'up' and 'down' are in terms of magnitude.

另請參閱

TRUNC: 忽略不重要的位數，將指定數字捨去到特定有效位數。

ROUNDUP: 將指定數字四捨五入到特定小數位數，而且一律無條件進入到下一個有效的遞增量。

ROUNDDOWN: 將指定數字四捨五入到特定小數位數，而且一律無條件捨去到下一個有效的遞增量。

MROUND: 將數字四捨五入到另一個最接近的整數倍數。

INT: 將數字無條件捨去到小於或等於此數字的最接近整數。

FLOOR: 將數字無條件捨去到最接近的指定基數之整數倍數。

CEILING: 將數字無條件進入到最接近的指定基數之整數倍數。

範例