## What is INT function in Excel?

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

It **Rounds **a number down to a **Nearest **integer.

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

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

6. Then select **ok**

7. In the function Arguments Tab you will see the **INT **function

8. In the **number section** you can enter the value to round (for **example 1.5**)

9. If you enter **+1.5** result will be **1**

10. If you enter **2.5** result will be **2**

11. If you enter **-1.5** result will be ** -2**

12. If you enter **-2.5** result will be **-3**

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

## Examples of **INT** function in excel

**INT****Example 1:**

**How to use INT function in excel**

You can see examples of INT function below:

**int**(2.4) ----->>>>answer is 2
**int**(1.4) ----->>>>answer is 1
**int**(0) ----->>>>answer is 0
**int**(-1.6) ----->>>>answer is -2
**int**(-2.6) ----->>>>answer is -3

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

**INT**It **Rounds **a number down to a **Nearest **integer.

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

**INT**It returns a number.

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

**INT**This function has just **1** Argument.

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

In the **number section** you can enter the value to round (for **example 1.5**).

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

```
INT(number) = number
```

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

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

## Errors in **INT** function

**INT****INT** related functions :

**related functions :**

**INT**- TRUNC Function
- ROUND Function
- ROUNDDOWN Function
- ROUNDUP Function
- MROUND Function
- FLOOR function
- CEILING function