**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.