ROUNDUP Function in Excel
Beginner
Rounds a number up, away from zero.
Syntax
=ROUNDUP(number, num_digits)Example
Use Case
Calculate minimum boxes needed (always round up partial boxes).
Common Errors to Avoid
- Always rounds away from zero, even for negative numbers
- ROUNDUP(-2.3, 0) = -3 (not -2)
- Different from CEILING - ROUNDUP uses num_digits, CEILING uses significance
Pro Tips
Perfect for inventory/packaging calculations where you need whole units. Use num_digits=0 for next whole number. For always rounding to nearest integer up, use CEILING instead. Combine with division for 'how many X fit in Y' problems.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →