## What is ROUNDDOWN function in Excel?

The **ROUNDDOWN **function is one of the math functions of Excel.

It **Rounds a number down**, toward zero.

We can find this function in **Math &trig** category of insert function Tab.

## How to use ROUNDDOWN 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 **ROUNDDOWN **function

6. Then select **ok**

7. In the function arguments Tab you will see ** ROUNDDOWN **function

8. Number is **any real number that you want to be rounded** down

9. Num_digits is the **number of digits** to which you want to round. **Negative **rounds to the left

of the decimal point; **zero **or omitted, to the **nearest **integer

10. You will see **results **in the formula result section

## Examples of **ROUNDDOWN** function in Excel

**Example 1:**

**How to use ROUNDDOWN function in excel**

You can see examples of ROUNDDOWN function below:

**rounddown**(A2,B2) ----->>>>answer is 123.4
**rounddown**(A3,B3) ----->>>>answer is 123.45
**rounddown**(A4,B4) ----->>>>answer is 123
**rounddown**(A5,B5) ----->>>>answer is 120
**rounddown**(A6,B6) ----->>>>answer is 100

## What is the purpose of **ROUNDDOWN** function?

**ROUNDDOWN**

It **Rounds a number down**, toward zero.

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

**ROUNDDOWN**

It returns a number.

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

**ROUNDDOWN**

This function has just **1** Argument.

The **argument **of ROUNDDOWN function is **number**.

Number is **any real number that you want to be rounded** down

Num_digits is the **number of digits** to which you want to round. **Negative **rounds to the left

of the decimal point; **zero **or omitted, to the **nearest **integer

The argument of ROUNDDOWN function is **required **and not optional.

```
ROUNDDOWN(number) = number
```

## Which version of excel supports **ROUNDDOWN** function?

**ROUNDDOWN**

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

## Errors in **ROUNDDOWN** function

**ROUNDDOWN**

## ROUNDDOWN** related functions :**

- ROUND function
- ROUNDUP function
- CEILING function
- FLOOR function
- MROUND function
- INT function
- TRUNC function