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:
Syntax: =ROUNDUP(A2,B2)
Result:
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:
Note:
- 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.
- The values of the 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.
