Using the Excel ROUND Function
SummaryThe 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)
The number argument is required in the ROUND function and is the number that you want to round.
The num_digits argument is also required. This is the number of digits to which you want to round the number argument.
Usage NotesThe 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.
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.