Excel FunctionsExcel ROUND Function

Excel ROUND function


The Excel ROUND function rounds a fractional number to a specified number of digits.

In the ROUND function, the general principle of rounding (i.e. roundup if proceeding digit is greater than 5) is observed.

The Excel ROUND Function is similar to the other ROUNDING FUNCTION (e.g. ROUNDUP and ROWNDOWN ) except in the other functions digit after point/ fraction is rounded up or down, whereas the ROUND function follows the general rule of rounding numbers.  


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.