ROUNDUP Function in Excel

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 Function
• ROUNDUP Formula in Excel
• How to Use ROUNDUP Function?

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.

Parameters

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.

Example #1

In this example we will take the value of Num_of_digits parameter in positive i.e. Num_of_digits >0:

Example #2

In this example we will take the value of Num_of_digits parameter = 0:

Example #3

In this example, we will take the value of Num_of_digits parameter < 0:

Things to Remember

1. The ROUNDUP formula is just like a ROUND function except it only rounds up the number upward
2. Both the parameters of ROUNDUP formula are mandatory and must be integer values in ROUNDUP Function.
3. Values of Num_of_digits parameter should be 1 to 9 only.
4. The ROUNDUP formula was first introduced in EXCEL 2013 and is available in all subsequent versions of Excel.

Recommended Articles

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 –

• VBA RoundUp
• Examples of EOMONTH
• ROUND Formula in Excel
• Insert Date in Excel
• How to use INT Function in Excel?
• TREND Function in Excel
• ROUNDDOWN Excel Function
• MONTH in Excel
• EDATE in Excel