Excel ROUND Function

Basic Description

The Excel Round function rounds a supplied number up or down, to a specified number of decimal places.

The syntax of the function is:

ROUND( number, num_digits )

Where the arguments are as follows:

number-The initial number.

The number of decimal places to round the supplied number to.

Note that:
  • a positive num_digits value specifies the number of digits to the right of the decimal point
  • a num_digits value of 0 specifies rounding to the nearest integer
  • a negative num_digits value specifies the number of digits to the left of the decimal point

The above arguments can be supplied as either simple numbers, references to cells containing numbers, or as values returned from other functions or formulas.

Round Function Examples

The following spreadsheet shows the Excel Round function used with different argument values :

1 =ROUND( 100.319, 1 )
25.28=ROUND( A2, 1 )
35.9999=ROUND( A3, 3 )
499.5=ROUND( A4, 0 )
5-6.3=ROUND( A5, 0 )
6-100.5=ROUND( A6, 0 )
7-22.45=ROUND( A7, 1 )
8999=ROUND( A8, -1 )
9991=ROUND( A9, -1 )
1 100.3

The above examples show how the Round function will round up or down, to the specified number of decimal places.

Further information on the Excel Round Function is provided on the Microsoft Office website.

Using the Round Function When Comparing Numbers in Excel:

It is often a good idea to use the Round function when comparing two numbers in Excel, especially if the numbers are the result of multiple mathematical calculations. This is because multiple calculations may result in the introduction of rounding errors, which may cause small inaccuracies in the numbers stored in Excel.

For example, the decimal 5.1 may, due to rounding errors, be stored in cell A1 of your spreadsheet, as 5.10000000000001. When compared to the exact value 5.1, the value in cell A1 will not be equal to the exact value 5.1.

However, applying the Round function to the value in cell A1 removes the rounding error.

ie. the expression

ROUND( A1, 1 ) = 5.1

or even

ROUND( A1, 10 ) = 5.1

will evaluate to TRUE.