Rounds a number up, away from zero.
ไวยากรณ์
ROUNDUP(number, num_digits)อาร์กิวเมนต์
numberจำเป็น
The real number you want to round up.
num_digitsจำเป็น
The number of digits to which you want to round the number.
The ROUNDUP function behaves like ROUND, except that it always rounds a number up. If num_digits is greater than 0, the number is rounded up to the specified number of decimal places; if it is 0 or negative, it rounds up to the nearest integer or left of the decimal point.
=ROUNDUP(3.2, 0)→4Rounds 3.2 up to the nearest integer.
=ROUNDUP(76.9, -1)→80Rounds 76.9 up to the nearest ten.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =ROUNDUP( followed by the number and the number of digits, then close the parenthesis.
ROUNDUP always rounds away from zero, whereas ROUND rounds to the nearest value based on standard rounding rules.