**Rational**

Rounding to a specified number of digits.

**Description**

The Excel ROUND function returns a number after rounding a supplied number or time to a specific number of digits.

For example, if you want to round a number, the formula can be **=ROUND(19.62159344,3)** the Excel returns a number to **19.621**, by turning a given numerical value to 3 decimal places.

**Syntax**

=ROUND (number, num_digits)

**Parameters**

**number** – The value to round**num_digits** – The number of digits to be rounded, like ‘3’ in the above example.

**Return Value**

A rounded number

**Key Notes**

The ROUND function round a number up or down based on the decimal value if the value is less than the halfway point (<0.5) the number is rounded down and vice versa if more than the halfway point.

For Example, 10.49 rounds down to 10 and 10.51 rounds up to 11, assuming rounded to zero decimal places.

In case you want to remove seconds from **time**(06:30:40) use formula, =Round(06:30:40,1) return **7:12**.

If *num_digits* is greater than 0 (zero), then the number is rounded to the specified number of decimal places.

For Example, **=ROUND(19.62159344,3)** returns a number **19.621**, round a digit to 3 decimal places. *num_digits *is 3 > 0.

If *num_digits* is 0, the number is rounded to the nearest integer.

For Example, =**ROUND(19.62159344,0)** returns a number **20**, round a digit to 0 decimal places, rounded up as decimal value is more than the half.

If *num_digits* is less than 0, the number is rounded to the left of the decimal point. For Example, **=ROUND(19621.59344,-2)** returns a number **19600**, rounded a digit to the nearest multiple of 100.

## Keep Reading Similar Functions:

### RAND

The RAND function generates a number in the decimals format between 0 to 1, =RAND()*10+10 always returns a decimal number falling between 10 and 20.

### RANDBETWEEN

The RANDBETWEEN function generates a set of random integers between two numbers, =RANDBETWEEN(10,50) returns always a random integer between 10 and 50.