ROUNDUP Formula Excel


Home >> How to Use Excel Tutorial >> Excel Formulas List >> 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


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

    ROUNDUP Formula Excel - Screenshot of Step 1

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

    ROUNDUP Formula Excel - Screenshot of Step 2

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

    ROUNDUP Formula Excel - Screenshot of Step 3

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

    ROUNDUP Formula Excel - Screenshot of Step 4

  5. Input close bracket sign

    ROUNDUP Formula Excel - Screenshot of Step 5

  6. Type Enter
  7. The process is done!

    ROUNDUP Formula Excel - Screenshot of Step 7



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

  1. What is the answer if we do rounding up to 5 decimal digits?
  2. What is the answer if we do rounding up to no decimal digit?
  3. 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!




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert