Description
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.
=ROUND(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.
