Rounds a number up, away from zero.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
ROUNDUP(number, num_digits)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)Ergebnis: 4
Rounds 3.2 up to the nearest integer.
=ROUNDUP(76.9, -1)Ergebnis: 80
Rounds 76.9 up to the nearest ten.
ROUNDUP always rounds away from zero, whereas ROUND rounds to the nearest value based on standard rounding rules.