What is ROUND function in Excel?
The ROUND function is one of the math functions of Excel.
It Rounds a number to a specified number of digits.
We can find this function in Math & trig category of insert function Tab.
How to use ROUND function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select math and trig category.
5. Select ROUND function.
6. Then select ok.
7. In the function arguments Tab you will see ROUND function.
8. Number Is the number you want to round.
9. Num_digits Is the number of digits to which you want to round.
Negative rounds to the left of the decimal point; zero to the nearest integer.
10. If you want to round that value to one decimal place, you can do the following:
11. If you want to round that value to two decimal places, you can do the following:
12. If you want to round that value to three decimal places, you can do the following:
13. If you want to round that value to four decimal places, you can do the following:
14. You will see results in the formula result section
Examples of ROUND function in Excel
Example 1:
How to use ROUND function in excel
ROUND rounds up when the last significant digit is 5 or greater, and rounds down when the last significant digit is less than 5.
You can see examples of ROUND function below:
round(A2,B2) ----->>>>answer is 123.5
round(A3,B3) ----->>>>answer is 123.46
round(A4,B4) ----->>>>answer is 123
round(A5,B5) ----->>>>answer is 120
round(A6,B6) ----->>>>answer is 100Example 2:
How to round to 1 decimal in Excel?
We want the number 256.423 to be rounded to one decimal place.
We use the following formula:
round(256.423,1) ----->>>>answer is 256.42Example 3:
How to round to 2 decimals in Excel?
We want the number 256.423 to be rounded to two decimal place.
We use the following formula:
round(256.423,2) ----->>>>answer is 256.4What is the purpose of ROUND function?
It Rounds a number to a specified number of digits.
What is the Return value of ROUND function?
It returns a number.
How many arguments does ROUND function have?
This function has just 2 Argument.
The argument of ROUND function is number.
Number Is the number you want to round.
Num_digits Is the number of digits to which you want to round.
The argument of ROUND function is required and not optional.
ROUND(number) = number
Which version of excel supports ROUND function?
This function is available for all excel versions (2003-2019).
Errors in ROUND function
If number is not numeric, ROUND returns a #VALUE! error.
