Rounds a number up, away from zero.
Sintassi
ROUNDUP(number, num_digits)Argomenti
numberobbligatorio
The real number you want to round up.
num_digitsobbligatorio
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.