# INT Function – Google Sheets

The INT function in Google Sheets rounds a number down to the nearest integer.

This function can simplify large numbers or convert decimal values to integers. You can also use it to filter data in a spreadsheet.

⚠️ The INT function will always round down to the nearest integer. If you use this function with a negative number, the INT function will round down to the nearest integer, even if the negative number is less than zero. See the second example for clarification.

## SYNTAX

The syntax for the INT function is:

`=INT(value)`

`value` – The number that you want to round down.

## Similar Functions

Several functions deal with rounding. Choose the most appropriate for your use.

• CEILING – Rounds a number up to the nearest integer multiple of specified significance
• INT – Rounds a number down to the nearest integer
• FLOOR – Rounds a number down to the nearest integer multiple of specified significance
• MROUND – Rounds one number to the nearest integer multiple of another
• ROUND – Round a number to a specified number of decimal places using standard rounding
• ROUNDDOWN – Round a number down to a specified number of places
• ROUNDUP – Round a number up to a specified number of places
• TRUNC: Truncates a number to a certain number of significant digits by omitting less significant digits

## INT Function Examples

Here are some examples of how you can use the INT function in Google Sheets:

### Example 1 – Round a Decimal to a Whole Number

To round down the number `12.345` to 12, you would use the following formula:

`=INT(12.345)`

### Example 2 – Negative Number

Next, let’s look at using INT on a negative number. We’ll use 12.345 again but switch the sign to `-12.345`.

`=INT(-12.345)`

The result is -13. It is important to realize this is a different result than rounding a number with the ROUND function. See a comparison of INT and ROUND for more.

### Example 3 – Filtering by Numbers

You can use this function to FILTER data in a spreadsheet. For example, the following formula would return all of the rows in a spreadsheet where the value in the `Price` column is an integer:

Formula used: `=FILTER(A4:B7, INT(B4:B7) = B4:B7)`

### Live Example in Google Sheets

Use a copy of this live Google Sheet for a quick start with the examples from above.