Generally, functions are predefined formulas that allow performing various mathematical operations in Excel. These functions and formulas are already available in Excel by default. You can use the INT function to return the integer portion of a given input number. It is one of the built-in functions in Excel categorized as a Math function.

This article explains the usage of the **Excel INT Function** with its basic syntax, explanation, and examples. Get an official version of** MS Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Jump To

## What is the INT Function?

INT is one of the **built-in functions** in Microsoft Excel. It comes under **Math **functions. We can use this function in our spreadsheet whenever we want to **round a given integer number down to the nearest integer**.

### 1) Syntax

- This is the basic syntax of the Excel INT Function.

**=INT(number)**

### 2) Arguments

**Number –**The input number which you want to round down to the nearest integer.

### 3) Motive

- This function will
**get the integer part of a number by rounding it down**.

### 4) Return Value

- It returns the
**integer part of a number**.

**Note:** If you give **non-numeric values** such as letters and special characters to the argument, it will return **#VALUE! Error**.

## What Will INT Function Do?

As we said earlier, the INT function will return the integer part of the given decimal number by rounding to its nearest value. We can **use **both **positive and negative integer** values. This function is categorized as “**Math**” in Excel. Let’s see an example scenario to make you understand it easily.

**Step 1:** Here, we have come up with a **set of decimal values** and want to round them to the nearest integer value using this INT function.

**Step 2:** Now, we need to **apply **the **following formula** in any cell where we want to get the result.

**=INT(B3)**

**Step 3:** Now, **click **on the **Enter **button to get the result.

**Step 4:** To fill down the remaining cells, you just drag down the first cell. It will **auto-fill the remaining cells** as shown in the below screenshot.

We hope that the given scenario helped you to understand the INT function. Move to the below section if you have any confusion related to the working nature of this function.

## Alternate Example

Here we will see how to apply the INT function in the spreadsheet with simple examples.

**1)** Suppose you want to round a specific value on your spreadsheet, then you can directly apply the formula in the cell.

**2)** For example, we want to **round the value -7.99**. We can apply the following formula in a cell where we want the result.

**=INT(-7.99)**

**3)** **Hit **the **Enter **button to get the result, as shown in the below image.

By doing so, you can quickly round down the decimal value to its nearest integer using the INT function.

## Expected Error while using INT Function

- If you give any non-numeric values such as letters and special characters in the argument, it will return
**#VALUE!**Error.

## Citations

To understand the usage of the INT function, we have referred to the following articles. They helped us to know the purpose of this function. You can also check them out using the links: INT function** ^{[1]}**, and What is Integer?

**.**

^{[2]}- https://stackoverflow.com/questions/58084071/microsoft-excel-using-int-function-with-time-format
- https://en.wikipedia.org/wiki/Integer

## End of the Article

With the help of the given scenarios and examples, you can easily understand the **purpose of the INT function** **in Excel** and how to apply it in the spreadsheet. The screenshots help to learn it even easier. Drop your **feedback **in the below comment section. Thanks for visiting **AawExcel**. Keep Learning!!

If you want to know what people think about this INT Function of Excel, then we suggest you look for it on the Quora interaction webpage. From there you can get to know more about the Excel INT function. Here, we have provided the link to Quora’s official website.

**Video Tutorial**

The following video will show you how to use the Excel INT function in the spreadsheet with proper examples.

**Deepak** is an Excel enthusiast and data analyst with over **5 years** of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!