Excel Core Book
Get our FREE guide on Excel when you subscribe to our free newsletter
Rounds the number to specified digits
Syntax of Excel Round formula:
=Round(this number, to this many digits)
Excel ROUND formula can round up or round down the number as per normal mathematics rule. Meaning if digit to be eliminated is 5 or greater than 5 then last remaining digit will be unchanged.
The num_digit argument in the function help specify the digit places:
If num_digit value is positive then it is simply dictating Excel about how many decimal places you want.
If num_digit value is negative then you are asking Excel to round as follows:
num_digit is -1 = Round to nearest 10
num_digit is -2 = Round to nearest 100
num_digit is -3 = Round to nearest 1000
If num_digit value is Zero then it will round the number to nearest integer.
=ROUND(5.8942,2) will return 5.89
=ROUND(8.67,1) will return 8.7
=ROUND(19.42,0) will return 19
=ROUND(225.87,-1) will return 230