ROUND function in Excel

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

  1. Click on an empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

 insert function tab in excel

4. Select math and trig category.

5. Select ROUND function.

6. Then select ok.

math and trig functions category in excel

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.

excel ROUND function

10. If you want to round that value to one decimal place, you can do the following:

How to use ROUND function in excel

11. If you want to round that value to two decimal places, you can do the following:

ROUND function in excel

12. If you want to round that value to three decimal places, you can do the following:

ROUND function in excel

13. If you want to round that value to four decimal places, you can do the following:

ROUND function in excel

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:

Examples of ROUND function in Excel
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  100

Example 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.42

Example 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.4

What 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.

ROUND related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *