Excel ROUND Function
The Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point.
Round a number to a given number of digits
A rounded number.
=ROUND (number, num_digits)
- number - The number to round.
- num_digits - The number of digits to which number should be rounded.
- Round works by rounding numbers 1-4 down, and rounding numbers 5-9 up.
- The ROUND function rounds numbers to a specified level of precision. It can round to the right or left of the decimal point.
- If num_digits > 0, number is rounded to the specified number of decimal places to the right of the decimal point.
- If num_digits < 0, number is rounded to the left of the decimal point (i.e. to the nearest 10, 100, 1000, etc.).
- If num_digits = 0, number is rounded to the nearest integer.
ROUND formula examples
If you need to round a number in a normal fashion (i.e. round values of 5 or more up and values less than 5 down) you can use the ROUND function with a specified number of digits. In the example, the formula in cell D6...
If you need to round a number to a given (variable) number of specified digits or figures, you can do so with an elegant formula that uses the ROUND and LOG10 functions. In the example shown, the formula in D6 is as...
If you need to round a number to the nearest 1000, you can use the ROUND function and supply -3 for number of digits. How this formula works In the example, cell C6 contains this formula: =ROUND(B6,-3) The value in...
If you need to round prices so that they ended in the nearest, .99 value, you can use the ROUND function then subtract .01. How this formula works The formula shown in the example is: =ROUND(B6,0)-0.01 With the...