Description
The Excel ROUNDUP function rounds a fractional number to a specified number of digits.
In the ROUNDUP function, the fractional number is rounded to the specified number of digits by rounding up the last digit.
The Excel ROUNDUP Function is similar to the other ROUNDING FUNCTION (e.g. ROUND and ROWNDOWN ) except in this function fractional number si rounded to a specific number of digit by rounding up the last digit.
In our example given in the image, the reference fractional number (i.e. 32.3546) is rounded to digits after points by rounding up the 2nd digit (i.e. 5) to 6.
=ROUNDUP(number,num_digits)
The ROUND function’s syntax has the following arguments:
- number Required.
This argument shall be the fractional number or reference to the fractional number you want to round. In the example given in the image above the number “32.3546” and the cell B4 (i.e. reference to the number) is our required argument.
- num-digit Required.
The number of digits till we want to round our required number.
