How to use ROUNDUP in Excel
Rounds up, away from zero.
Syntax
numberThe numbernum_digitsHow many decimal placesExample
Here’s ROUNDUP on a small table of orders. The highlighted cells are the ones the formula reads.
=ROUNDUP(AVERAGE(E2:E9),0)Edit this formula live Change the ranges and watch the answer update. Free, no sign-up.
Common mistakes with ROUNDUP
It always rounds away from zero
=ROUNDUP(2.01,0) is 3, and =ROUNDUP(-2.01,0) is -3. Use ROUND for normal rounding.
Digits is required
Unlike ROUND in some apps, ROUNDUP needs the second argument. Use 0 for whole numbers.
What the error messages mean
Type these slips into Gridwise and this is the feedback you get:
Leaving off the closing bracket
=ROUNDUP(AVERAGE(E2:E9),0
Parentheses don’t match. You have 2 opening and 1 closing parentheses. Every ( needs a ).
Questions
What does the ROUNDUP function do in Excel?
Rounds up, away from zero. The syntax is ROUNDUP(number, num_digits).
Why is my ROUNDUP formula giving the wrong answer?
It always rounds away from zero: =ROUNDUP(2.01,0) is 3, and =ROUNDUP(-2.01,0) is -3. Use ROUND for normal rounding. Digits is required: Unlike ROUND in some apps, ROUNDUP needs the second argument. Use 0 for whole numbers.
Does ROUNDUP work in Google Sheets?
Most Excel functions, including the core ones on this page, work the same way in Google Sheets. A few newer functions arrived in Sheets later or behave slightly differently, so test it on your own data.