ROUND

Using the Excel ROUND Function

Summary

The Excel ROUND function is used to round a number to a user specified number of digits. The function can be used to round to the right or left of the decimal point. If you need a function that always rounds up (away from zero), use ROUNDUP. If you require a function that always rounds down (toward zero), use ROUNDDOWN.

Syntax

=ROUND (number, num_digits)

Syntax Breakdown

number
The number argument is required in the ROUND function and is the number that you want to round.

num_digits
The num_digits argument is also required. This is the number of digits to which you want to round the number argument.


Usage Notes

The ROUND function rounds a number to a specified number of digits. ROUND follows normal rounding rules. Numbers from 1-4 are rounded down, while numbers 5-9 are rounded up.

num_digits Notes
If num_digits is less than 0, the number argument will be rounded to the left of the decimal point. For example, to the nearest 10, 100, or 1,000.

If num_digits is greater than 0, the number argument will be rounded to the right of the decimal point.

If num_digits is equal to 0, the number argument will be rounded to the nearest integer.