Excel FunctionsExcel ROUNDUP Function

Excel ROUNDUP function


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.


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.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.