ROUNDUP Formula Excel
In this tutorial, we will explain how to use the ROUNDUP formula. This excel round up formula can be used to round up a number with the number of decimal digits we need.
Why do We Need to Learn Excel ROUNDUP Function?
In processing numeric data in excel, we often need to reduce the number of decimal digits from our results. This is so we can get the form of numeric data that we want. In the decimal adjustment process, there is also a case where we need to round the digit up. A normal rounding process can make the result becomes wrong and error for us.
One of the examples in work where this is needed is when we want to assign sales targets. The assignment is done to all salespeople in our company. After we get the division result of the target, it is better that we round the results. This is to make sure the company target is achieved when all salespeople reach their sales targets.
To help that process, there is the ROUNDUP formula in excel that can be used. ROUNDUP function in excel is almost like other rounding formulas in the spreadsheet. However, in its process, it will round up the digit that becomes its input. This is different from the process done by ROUND (round normally) or ROUNDDOWN (round down).
What is ROUNDUP Formula Excel?
ROUNDUP formula excel is a formula that can be used to adjust decimal digits up. This formula becomes important to understand because sometimes decimal numbers processing need that kind of adjustment.
A bit explanation about the inputs in this formula is as follows:
=ROUNDUP(number, num_digits)
Note:
 number: the number to be rounded up
 num_digits: the number of decimals that you want in the result
How to Use ROUNDUP Excel?
The following will explain about how to use ROUNDUP excel. It is pretty easy to use because its understandable inputs and the usage is similar to other rounding formulas.
Using ROUNDUP Formula Excel

Type equal sign ( = ) in the cell where you want to put the result in

Type ROUNDUP (can be with large and small letters) and open bracket sign after =

Input the number / cell coordinate where it is after the open bracket sign. Then, type a comma sign ( , )

Input the number of decimal digit demanded / cell coordinate where that is

Input close bracket sign
 Type Enter

The process is done!
Exercise
After you learn how to use the ROUNDUP formula in excel above, you can practice your understanding through the exercise below!
Download the exercise file and answer the questions. Download the answer key file if you have done the exercise and want to check your answers. Or if you are confused about how to answer the questions!
Link to the exercise file:
Download here
Questions
 What is the answer if we do rounding up to 5 decimal digits?
 What is the answer if we do rounding up to no decimal digit?
 What is the answer if we do rounding up to a thousand multiplication factor? (look at the additional notes section to learn how to do this!)
Link to download answer file:
Download here
Additional Notes

In the input of decimal digit demanded, if you type a negative number, then the result will become as follows:
 (1) will process into the multiplication factor of 10
 (2) will process into the multiplication factor of 100
 (3) will process into the multiplication factor of 1000
 etc
 If what you need is to round up to the nearest multiple, then learn how to use the CEILING formula. You can learn it by visiting this tutorial!