Excel ROUND Function (Table of Contents)
ROUND in Excel
Just like the format option in excel, ROUND Function change the display value or alter the original value in a cell. The ROUND function rounds a number to a specified number of digits. The ROUND function rounds the given number to the right or left of the decimal places. This function is categorized under Math and Trigonometry function.
ROUND Formula in Excel
Below is the ROUND Formula in Excel :
The ROUND Function has the following arguments:
- number – The number which needs to be round.
- num-digits – The number of digits to which give number should be rounded.
As ROUND Function is the part of Math & Trig Function, it found under ‘Formulas’ tab. Please follow the below step:
- Click on Formulas tab.
- Select Math & Trig Option.
- Select ROUND Function from the above drop-down menu list.
- After clicking on ROUND Function, it will open a pop-up for function arguments:
- Under number field, enter a number which needs to be round.
- Under num_digit field, enter a number of digits to which you want to round.
How to Use the ROUND Function in Excel?
ROUND Function in Excel is very simple and easy to use. Let understand the working of ROUND Function in Excel by some ROUND Formula example.
Example #1
From the below-given data extract the round values.
So the Result will be:
Similarly, we find other values by using the ROUND Function.
Example #2
From the below-given data extract the round values.
So the Result will be:
We can drag the formula by using Ctrl + D or double click on the right corner of the cell C15. So the result would be:
Explanation:
- If you want to round a number to the nearest 1000, we use ROUND Function and pass -3 in the place of the second argument.
- For rounding a number to the nearest 100, pass -2 in place of the second argument.
- For rounding a number to the nearest 10, pass -1 in place of the second argument.
If you want to round a number in a simpler way, you can use ROUND Function with the specified number of digits.
Example #3
From the below-given data extract the round values.
So the result will be:
We can drag the formula by using Ctrl + D or double click on the right corner of the cell C27. So the result would be:
Example #4
From the below-given data extract the round values.
So the Result will be:
We can drag the formula by using Ctrl + D or double click on the right corner of the cell C38. So the result would be:
Things to Remember about ROUND Function in Excel
- Round Function rounds a number 1-4 down and 5-9 up by rounding numbers.
- This Function rounds numbers to a specified level of precision. It rounds to the left or left of the decimal point.
- If the second argument num_digits is greater then 0, then the given number is rounded to the right of the decimal point.
- If the second argument num_digits less then 0, then the given number is rounded to the left of the decimal point.
- If num_digits = 0, then a number is rounded to the nearest integer.
- To always round up away from Zero use ROUNDUP Function.
- To always round down towards Zero use ROUNDDOWN Function.
- To round a number to a specific multiple of a digit, use the MROUND Function.
Recommended Articles
This has been a guide to ROUND Function in excel. Here we discuss the ROUND Formula in excel and how to use ROUND Function in excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –
