Excel ROUND Function (Example + Video)
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:
2 thoughts on “How to Use Excel ROUND Function (Examples + Video)”
Thanks well explained.
Thanks for commenting Gopala.. Glad you liked it 🙂