# Excel ROUND function

## Summary

The Excel ROUND function returns the rounded number of given number to the specified number of digits. The ROUND function will round up or down depending on the number.

## Function

=ROUND(number, num_digits)

## Arguments (inputs)

number = the number to round, can be a number or a cell reference

num_digits = The number of digits to round the number to. Zero (0) will round to the nearest integer and negative numbers will round to the left of the decimal point.

## Return value

The ROUND function returns numerical value that is the rounded value of the number provided.

## Example: rounding to the nearest integer

In the example above the ROUND function rounds the prices in column E to the nearest integer (0 instructs the ROUND function to round to the integer).

=ROUND(E6,0)

The result returned in cell G6 is \$262.

## Example: rounding to the nearest hundred

In the example above the ROUND function rounds the prices in column E to the nearest hundred (negative numbers round to the left of the decimal).

=ROUND(E6,-2)

The result returned in cell G6 is \$300.