## 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 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?

**ROUND**

It **Rounds a number** to a specified number of digits.

## What is the Return value of **ROUND** function?

**ROUND**

It returns a number.

## How many arguments does **ROUND** function have?

**ROUND**

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?

**ROUND**

This function is available for all excel **versions **(2003-2019).

## Errors in **ROUND** function

**ROUND**

If *number* is not numeric, ROUND returns a **#VALUE!** error.