How to use the Excel ROUNDUP function

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.

Syntax: =ROUNDUP (number, num_digits)

The ROUNDUP function syntax has the following arguments:

  • number – The number to round up.
  • num_digits – The number of digits to which number should be rounded up.

Example: Let’s look at some Excel ROUNDUP function examples and explore how to use the ROUNDUP function as a worksheet function in Microsoft Excel:

Excel ROUNDUP function - How to use the Excel ROUNDUP function

Syntax:  =ROUNDUP(A2,B2)

Result:

ROUNDUP function 1 - How to use the Excel ROUNDUP function

Based on the Excel spreadsheet above, the following ROUNDUP examples would return:

Syntax: =ROUNDUP(A3,B3)
Result: 587

Syntax: =ROUNDUP(A4,B4)
Result: 800.259

Syntax: =ROUNDUP(A5,B5)
Result: -800.3

Syntax: =ROUNDUP(A6,B6)
Result: 800.3

Syntax: =ROUNDUP(A7,B7)
Result: 800.26

Syntax: =ROUNDUP(A8,B8)
Result: 810

Syntax: =ROUNDUP(A9,B9)
Result: 900

Syntax: =ROUNDUP(A10,B10)
Result: 36000

Syntax: =ROUNDUP(A11,B11)
Result: 40000

Now below is the comparison between ROUNDUP function and ROUND function results:

ROUNDUP function in excel - How to use the Excel ROUNDUP function

Note:

  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. The values of the 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.
READ:  How to use the Excel ARABIC function

Add a Comment

Your email address will not be published. Required fields are marked *