INT Function – Google Sheets

Adam Steinfurth

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.

⚠️ If you use this function with a negative number, the INT function will round away from 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.MATH – Rounds a number up to the nearest integer multiple of specified significance with custom negative number treatment
  • CEILING.PRECISE – Rounds a number up to the nearest integer multiple of specified significance
  • INT – Rounds a number down to the nearest integer
  • FLOOR.MATH – Rounds a number down to the nearest integer multiple of specified significance with custom negative number treatment
  • FLOOR.PRECISE – Rounds a number down to the nearest integer multiple of specified significance
  • MROUND – Rounds a number to the nearest multiple of another number
  • ROUND – Rounds 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)

Web banner showing math symbols from the Insert Special Characters Add-On
Insert Any Math Symbol with One Click

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:

The INT function working as a filter
Using the INT Function to Filter Values

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.

Video Tutorial

YouTube player