Excel ROUND Function Formula

In Microsoft Excel, the ROUND function returns a number rounded to a specified number of digits. 

Syntax

The syntax for the ROUND function is:

ROUND( number, digits )

number is the number to round.
digits is the number of digits to round the number to.

Worksheet Function Example

Let's take a look at an example to see how you would use the ROUND function in a worksheet:

Based on the Excel spreadsheet above, the ROUND function would return the following:

=ROUND(A1, 0)	would return 663
=ROUND(A1, 1)	would return 662.8
=ROUND(A2, -1)	would return 50
=ROUND(55.1, -1)	would return 60
=ROUND(-23.67, 1)	would return -23.7