How to Use ROUNDUP Function in Excel (6 Examples)

The ROUNDUP function in Excel rounds a number up or to the higher side either right or left to the decimal point. In this article, you will get to know the introduction and usage of the ROUNDUP function in Excel.

Excel ROUNDUP Function


Download Workbook


ROUNDUP Function: Syntax & Arguments

⦿ Function Objective

The ROUNDUP function rounds a number up, away from zero.

⦿ Syntax

ROUNDUP(number, num_digits)

Excel ROUNDUP Function

⦿ Arguments

Argument Required/Optional Explanation
number Required The number to round up.
num_digits Required The place at which the number should be rounded.

⦿ Return Value

The ROUNDUP function returns a rounded number.

⦿ Version

The ROUNDUP function has been introduced in Excel 2003 version and available for all versions after that.


6 Examples of Using The ROUNDUP Function in Excel

Here, we have used the following two tables for demonstrating the applications of the ROUNDUP function in Excel.

For creating the article, we have used Microsoft Excel 365 version, you can use any other versions according to your convenience.

Excel ROUNDUP Function

Excel ROUNDUP Function


1. Rounding a Number Up to The Nearest Whole Number

Here, we will round up the times of the following table to the nearest whole number by using the ROUNDUP function.

Excel ROUNDUP Function

➤Select the output cell D5
➤Type the following formula

=ROUNDUP(C5,0)

Here, C5 is the time which we want to round up and 0 is the number digit that will round up the value to the nearest whole number.

whole number

➤Press ENTER
➤Drag down the Fill Handle Tool

whole number

Result:
In this way, you will be able to round up the times to the nearest integer number.

whole number

Similarly, you can get the result by inserting direct input instead of reference like below.

=ROUNDUP(1260.98769,0)

whole number


2. Rounding a Number Up with a Positive Number Digit

You can round up the values for any positive number digits to the right of the decimal point by using the ROUNDUP function.

Excel ROUNDUP Function

➤Select the output cell D5
➤Type the following formula

=ROUNDUP(C5,1)

Here, C5 is the time which we want to round up and 1 is the number digit that will round up the value to 1 decimal place.

positive number digit

➤Press ENTER
➤Drag down the Fill Handle Tool

positive number digit

Result:
After that, you will be able to round up the times to one place right of the decimal point.

positive number digit

You can round up the times to two places right of the decimal point by using the following formula.

=ROUNDUP(C5,2)

Here, C5 is the time which we want to round up and 2 is the number digit that will round up the value to 2 decimal places.

positive number digit

For rounding up the times to three places right of the decimal point you can use the following formula.

=ROUNDUP(C5,3)

C5 is the time which we want to round up and 3 is the number digit that will round up the value to 3 decimal places.

Excel ROUNDUP Function

Similarly, you can round up the values for any number of decimal places by increasing the number digit of the ROUNDUP function.


3. Rounding a Number Up with a Negative Number Digit

In this section, we will round up the values for any negative number digits to the left of the decimal point by using the ROUNDUP function.

Excel ROUNDUP Function

➤Select the output cell D5
➤Type the following formula

=ROUNDUP(C5,-1)

Here, C5 is the distance which we want to round up and –1 is the number digit.
This negative number will round up the value to the nearest 10.

negative number digit

➤Press ENTER
➤Drag down the Fill Handle Tool

negative number digit

Result:
Then, you will round up the distances to one place left of the decimal point.

negative number digit

You can round up the distances to two places left of the decimal point by using the following formula.

=ROUNDUP(C5,-2)

Here, C5 is the distance which we want to round up and –2 is the number digit that will round up the value to the nearest 100.

negative number digit

For rounding up the distances to three places left of the decimal point, you can use the following formula.

=ROUNDUP(C5,-3)

Here, C5 is the distance which we want to round up and –3 is the number digit that will round up the value to the nearest 1000.

Excel ROUNDUP Function

Similarly, you can round up the values for any number of digits to the left of the decimal places by changing the number digit of the ROUNDUP function.


Similar Readings


4. Using The ROUNDUP Function in a Formula

Here, we will determine the speed of the participants by dividing the distances by times, and then we will round up the values to the two decimal places by using the ROUNDUP function.

Excel ROUNDUP Function

➤Select the output cell E5
➤Type the following formula

=ROUNDUP((C5/D5),2)

Here, C5 is the distance and D5 is the time

  • (C5/D5)→It will divide the distance by the time.
    Output→1.15748
  • ROUNDUP((C5/D5),2) becomes
    ROUNDUP(1.15748,2)→It will round up the value to two decimal places by using the number digit 2.
    Output→1.16

formula

➤Press ENTER
➤Drag down the Fill Handle Tool

formula

Result:
Then, you will get the speed to 2 decimal points.

formula


5. Using The ROUNDUP Function in a VBA Code

You can use the ROUNDUP function in the VBA code also. 

Excel ROUNDUP Function

➤Go to Developer Tab>>Visual Basic Option

VBA

Then, the Visual Basic Editor will open up.
➤Go to Insert Tab>> Module Option

VBA

After that, a Module will be created.

VBA

➤Write the following code

Sub roundnumber()

    Range("D5") = Application.WorksheetFunction.RoundUp((Range("C5")), 2)
    Range("D6") = Application.WorksheetFunction.RoundUp((Range("C6")), 2)
    Range("D7") = Application.WorksheetFunction.RoundUp((Range("C7")), 2)
    Range("D8") = Application.WorksheetFunction.RoundUp((Range("C8")), 2)
    Range("D9") = Application.WorksheetFunction.RoundUp((Range("C9")), 2)
    Range("D10") = Application.WorksheetFunction.RoundUp((Range("C10")), 2)

End Sub

ROUNDUP will round up the values of the cells C5 to C10 of Column C to 2 decimal places and we will get the outputs in corresponding cells of Column D.

VBA

➤Press F5

Result:
Finally, you will get the distances rounded up to the two places right of the decimal point.

Excel ROUNDUP Function


6. Using The ROUNDUP Function for Negative Values

For the negative temperature of the substances, you can also round them up by using the ROUNDUP function.

Excel ROUNDUP Function

We will try to get the nearest negative integers by using the following formula

=ROUNDUP(C5,0)

Here, C5 is the negative temperature that we want to round up and 0 is the number digit that will round up the value to the nearest whole number.

negative values

You can round up the negative temperatures to two places right of the decimal point by using the following formula.

=ROUNDUP(C5,2)

Here, C5 is the negative temperature that we want to round up and 2 is the number digit that will round up the value to 2 decimal places.

negative values

For rounding up the negative temperatures to two places left of the decimal point, you can use the following formula.

=ROUNDUP(C5,-2)

Here, C5 is the negative temperature that we want to round up and –2 is the number digit that will round up the value to the nearest 100.

negative values


Things to Notice

🔺The ROUNDUP function is quite similar to the ROUND function, but it always rounds a number up.

🔺It rounds the number 1-9 up.

🔺This function can round up the number both to the right and left of the decimal point.


Practice Section

For doing practice by yourself we have provided a Practice section like below in a sheet named Practice. Please do it by yourself.

practice


Conclusion

In this article, we tried to cover the introduction and usage of the ROUNDUP function in Excel. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.


Related Articles

Tanjima Hossain

Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo