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.
This was the entire process of rounding up in excel. Let’s see some more ways to use roundup.
Excel Roundup to nearest Whole Number
We can use roundup to round off to the nearest whole number.
Type =ROUNDUP(A2,0)
0 tells excel to round up to a whole number.
Excel Roundup to nearest 5
Type =ROUNDUP(A2,-0.5)
-0.5 tells excel to round up to nearest 5.
Excel Roundup to nearest 100
Type =ROUNDUP(A2,-2)
-2 will tell excel to round up to 2 decimal places from left i.e. to nearest 100
Excel Roundup to nearest 1000
Type =ROUNDUP(A2,-3)
-3 will roundup to nearest 1000 in excel.
Other Round Functions in Excel
Do checkout other round formulas in excel.
- Excel round formula to round values normally
- Excel round down formula to round down to nearest values.
Conclusion
This was all about excel round up function and how the process of rounding up in excel works.
We hope know you know how to round numbers up in excel as well as how to roundup to nearest whole number, 5, 100 and 100.
If you have any doubts or suggestions for us, then leave a comment below and our team will get back to you.
Advanced Excel Course
Learn Vlookup, Pivot tables, What IF, Macro Automation, Power Query and much more.
- 10+Hrs of Learning Content
- 50+ Practical Exercises
- Certification
- Doubt Resolution