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.

Contents

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

## Insert Math Symbols (Add-On)

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