Syntax
ROUNDUP(number, num_digits)
| Parameter | Description |
|---|---|
| number | Parameter of the ROUNDUP function. |
| num_digits | Parameter of the ROUNDUP function. |
Examples
Price rounding
Formula
=ROUNDUP(24.3521, 2)
Returns 24.36. Rounds up to 2 decimal places. Use this for pricing where you never want to undercharge.
Ceiling to whole number
Formula
=ROUNDUP(7.001, 0)
Returns 8. Even though 7.001 is barely above 7, ROUNDUP pushes it to 8 since it always rounds away from zero.
Round to tens
Formula
=ROUNDUP(1423, -2)
Returns 1500. Negative num_digits rounds to the left of the decimal: -1 for tens, -2 for hundreds, -3 for thousands.
Common Errors
#VALUE!
Non-numeric input like =ROUNDUP("abc", 2) returns #VALUE!.
#NUM!
Extremely rare, but could occur with unusual edge cases in the num_digits argument.
Tips
Negative numbers go more negative
ROUNDUP(-3.2, 0) returns -4, not -3, because it rounds away from zero. This is different from CEILING which rounds toward positive infinity.
Material and time estimates
When calculating how many tiles, planks, or hours you need, always use ROUNDUP to avoid coming up short.
Use negative digits for large rounding
ROUNDUP(12345, -3) returns 13000. Negative second argument rounds to thousands, ten-thousands, etc.
Try ROUNDUP in Viztab
Import your data and use ROUNDUP with 370+ other formulas. No signup required.
Open Viztab