Excel Functions Tutorials
- Maths Functions in Excel
- ABS Function in Excel
- AGGREGATE Excel Function
- CEILING Excel Function
- COMBIN Excel Function
- COS Excel Function
- EVEN Function in Excel
- EXPONENTIAL Excel Function
- Excel Matrix Multiplication
- Excel Minus Formula
- FLOOR Function in Excel
- Histogram Formula
- INT Excel Function (Integer)
- LN Excel Function
- LOG Excel Function
- Mode in Excel
- ODD Function in Excel
- POWER Function in Excel
- PRODUCT Excel Function
- PRODUCT Formula in Excel
- PI in Excel
- Quotient in Excel
- Running Total in Excel
- RAND Excel Function
- Rand Excel Formula
- RANDBETWEEN in Excel
- MROUND in Excel
- ROUND in Excel
- ROUND Formula in Excel
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- SIGN Excel Function
- SIN Excel Function
- Square Root in Excel (SQRT)
- SUBTOTAL Excel Function
- SUM Function in Excel
- SUM Formula in Excel
- Excel SUM Shortcut
- SUMIF in Excel
- SUMIFS in Excel
- SUMIF Not Blank
- SUMIFS with Dates
- SUMIF Between Two Dates
- Sumif Text in Excel
- SumIf with Multiple Criteria
- SUMPRODUCT Function in Excel
- SUMPRODUCT Formula in Excel
- SUMPRODUCT with Multiple Criteria
- How to Sum Multiple Rows in Excel?
- TAN Excel Function
- TANH in Excel
- Average vs Weighted Average
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
- Power Bi (35+)
ROUNDUP function in excel is an inbuilt function in excel which is used to calculate the rounded value of the number to its highest degree, or in other words it rounds the number away from zero so if the input provided to this function is =ROUNDUP(0.40,1) we will get 0.4 as a result, this function takes two arguments one being the number and another is the number of digits.
ROUNDUP Function Excel (Table of Contents)
ROUNDUP in Excel
The ROUNDUP function is one of the mathematical functions of Excel. The main purpose of the ROUNDUP function is to round up the given floating point number to a provided number of decimal places. Unlike ROUND function or ROUNDDOWN function, ROUNDUP Function always rounds the number upward to a specified place of decimal. ROUNDUP is quite useful while handling floating point number, or working on some VBA calculation related projects.
ROUNDUP Formula in Excel
Below is the ROUNDDOWN Formula in Excel.
As it is clear from the syntax shown above the ROUNDUP formula has two parameters which are as follows:
Number: The number parameter is a mandatory parameter of the ROUNDUP formula. It defines the floating point number which needs to be rounded up.
Num_of_digits: This parameter is also mandatory for the ROUNDUP ROUNDUP formula to work. This parameter defines the number of digits you would like to round the provided Number to. This parameter can be positive, negative or zero.
If Num_of_digits = 0: It means the Number will be rounded up to the nearest integer number.
If Num_of_digits < 0: It means the Number will be rounded up to the nearest 10, 100, 1000, and so on; depending upon the value of Num_of_digits.
If Num_of_digits > 0: It means the Number will be rounded up to the number of decimal places defined by the value of Num_of_digits
These conditions will be much clearer with the help of examples explained in the next section.
How to Use ROUNDUP Function in Excel?
In this section, we will understand the uses of the ROUNDUP formula and will look at a few examples with the help of actual data.
The ROUNDUP function is really easy to use, and as explained in the previous section, ROUNDUP function in Excel uses two mandatory parameters.
In this example we will take the value of Num_of_digits parameter in positive i.e. Num_of_digits >0:
In this example we will take the value of Num_of_digits parameter = 0:
In this example, we will take the value of Num_of_digits parameter < 0:
Things to Remember
- The ROUNDUP formula is just like a ROUND function except it only rounds up the number upward
- Both the parameters of ROUNDUP formula are mandatory and must be integer values in ROUNDUP Function.
- Values of Num_of_digits parameter should be 1 to 9 only.
- The ROUNDUP formula was first introduced in EXCEL 2013 and is available in all subsequent versions of Excel.
This has been a guide to ROUNDUP Function Excel. Here we discuss the ROUNDUP Formula in excel and how to use ROUNDUP function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –