ROUND

Rounding to a specified number of digits in Excel
Rounds a number to a specified number of digits

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:

Retrun random number within a range in Excel

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.

Read More »
Generate a random number between 0 and 1 in Excel

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.

Read More »