It can be during simple calculations or it can complex ones, you might want to round off a few numbers.
Excel ROUND Function can help you with that.
If it is that you only want to hide them from displaying, then be cautious of it…Go with formatting option instead of ROUND function.
Let us see how to use it in detail…
1. What is a ROUND Function?
2. What is the Syntax?
3. How to use it with an example?
1. What is a ROUND Function?
ROUND: The ROUND function can be used to round off a number to desired decimals either to the right or left.
- ROUNDUP: The ROUNDUP function can be used to round up (away from zero).
- ROUNDDOWN: The ROUNDDOWN function can be used to round up (towards zero).
- MROUND: The MROUND function can be used to round a number to a given nearest multiple.
2. What is the Syntax?
=ROUND(Number, No of Digits)
- Number – A number, which you want to round.
- No of Digits – The no of digits to which you want to round the number supplied.
Note :
- If No of Digits is greater than 0, then the number is rounded to the right of the decimal point.
- If No of Digits is less than 0, then the number is rounded to the left of the decimal point.
- If No of Digits is equal to 0, then the number is rounded to the nearest integer.
3. How to use it with an example?
Assuming we have a set of percentage, let’s quickly look at the functionality!!!
Find the examples for the below:
1. ROUND
2. ROUNDUP
3. ROUNDDOWN
4.MROUND
***ROUND***
1. Round a number to two decimal places
2. Round a number to one decimal place
3.Round a number to the nearest integer
4. Round a number to the nearest 10
5. Round a number to the nearest 100
***ROUNDUP***
***ROUNDDOWN***
***MROUND***
Hope it has helped you…