Rounds a number up, away from zero.
Ta funkcja działa w Arkuszach Google tak samo jak w Excelu — ta sama składnia i argumenty.
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)Wynik: 4
Rounds 3.2 up to the nearest integer.
=ROUNDUP(76.9, -1)Wynik: 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.