What ROUNDUP does
ROUNDUP forces a number upward, away from zero, to the number of digits you specify. It is useful when values should always round in the conservative direction, such as minimum charges, packaging counts, or quantity planning.
Practical examples
Round up to the next whole number
=ROUNDUP(A2,0)
If A2 contains 22.31, the result is 23.
Round up to the nearest hundred
=ROUNDUP(A2,-2)
A negative num_digits rounds to the left of the decimal point.
Common mistakes and notes
ROUNDUP is different from display formatting
Formatting can hide digits visually, but ROUNDUP changes the returned value itself.
Negative numbers also round away from zero
That means -2.1 rounded up with ROUNDUP becomes -3, not -2.
Use ROUND when standard rounding is enough
If values should round normally instead of always moving upward, use ROUND instead.