Excel Roundup Formula | How to round numbers up in Excel

As you know round function in excel is used to round numerical values, there are two more variations of the round function – excel roundup function and excel rounddown function.

Let’s see the difference.

Example: We want to round the numerical value 13.
If we use Round function then excel will return 10 as it’ll round the value to nearest 10.
If we use Roundup in excel then it’ll return 20 as it’ll round up the values irrespective of any other factor.
Similarly round down in excel will return 10.

Here’s a tutorial on excel round formula and excel round down formula, in case you’re interested.

Now let’s deep dive into the excel roundup formula and rounding up in excel works.

Table of Contents

Excel Round Up Function Syntax

Here’s the syntax of the roundup formula in excel.

=ROUNDUP(Number,Number_Digits)

Number: Means the numerical value you want to roundup.
Number_Digits: Means the number of decimal places you want excel to round up the number to.

Note: The argument Number_Digits can be positive as well as a negative number. Positive numbers means the value will be rounded to the right of decimal point and negative means the value will get rounded to the left.
0 means it’ll be rounded to nearest 1.

How to use Excel Roundup Formula

Select the cell and type =ROUNDUP(A2,2) Hit enter.

Excel will round up the value up-to 2 decimal places
Let’s use a negative value in Number_Digits. Type =ROUNDUP(A2,-3)

Now you can see excel has rounded up the value up-to 3 decimal places to the left.