ROUND

Excel Functions

Round a number to a given number of digits

Syntax

EXCEL

=ROUND(number, num_digits)

Arguments

Parameter	Description
`number`	The number to round.
`num_digits`	The place at which number should be rounded.

Return Value

A rounded number.

Details

The ROUND function rounds a number to a given number of places. ROUND rounds up when the last significant digit is 5 or greater, and rounds down when the last significant digit is less than 5. ROUND takes two arguments, number and num_digits. Number is the number to be rounded, and num_digits is the place at which the number should be rounded. When num_digits is greater than zero, the ROUND function rounds on the right side of the decimal point. When num_digits is less or equal to zero, the ROUND function rounds on the left side of the decimal point. Use zero (0) for num_digits to round to the nearest integer. This behavior is summarized in the table below: Rounding simplifies numbers by decreasing the number of digits while keeping the number close to its original value. The result is les

Examples

How ROUND works

We can get the same result with the ROUND function by providing 1 as num_digits:

EXCEL

=ROUND(2.786,1) // returns 2.8

Round to right

To round values to the right of the decimal point, use a positive number for digits:

EXCEL

=ROUND(A1,1) // Round to nearest tenth (0.1)
=ROUND(A1,2) // Round to nearest hundredth (0.01)
=ROUND(A1,3) // Round to nearest thousandth (0.001)
=ROUND(A1,4) // Round to nearest ten-thousandth (0.0001)

Round to left

To round down values to the left of the decimal point, use zero or a negative number for digits:

EXCEL

=ROUND(A1,0) // Round to nearest whole number
=ROUND(A1,-1) // Round to nearest 10
=ROUND(A1,-2) // Round to nearest 100
=ROUND(A1,-3) // Round to nearest 1000
=ROUND(A1,-4) // Round to nearest 10000

Nesting inside ROUND

Other operations and functions can be nested inside the ROUND function. For example, to round down the result of A1 divided by B1, you can ROUND in a

EXCEL

=ROUND(A1/B1,0) // round result to nearest integer

ROUND

Syntax

Arguments

Return Value

Details

Examples

See Also