When to use Excel ROUND Function
ROUND function can be used when you want to return a number rounded to a specified number of digits.
What it Returns
A number rounded to a specified number of digits.
Syntax
=ROUND(number, num_diguts).
Input Arguments
number – the number that you want to round. num_digits – the number of digits to which you want to round the number argument.
Additional Notes
If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. For example, =ROUND(500.51,1) would return 500.5. If num_digits is 0, the number is rounded to the nearest integer. For example, =ROUND(500.51,0) would return 501. If num_digits is less than 0, the number is rounded to the left of the decimal point. For example, =ROUND(500.51,-1) would return 501.
Excel ROUND Function – Live Example
Excel ROUND Function – Video Tutorial
Related Excel Functions:
Excel INT Function. Excel MOD Function. Excel RAND Function. Excel RANDBETWEEN Function. Excel RANK Function. Excel LARGE Function. Excel MAX Function. Excel MIN Function. Excel SMALL Function
Other Useful Excel tutorials:
How to Stop Excel from Rounding Numbers (Decimals/Fractions) How to Round to the Nearest Integer or Multiple of 0.5 / 5 / 10 in Excel
