# ROUND

## 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.

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.