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.

⚠️ 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

Insert Math Symbols (Add-On)

Web banner showing math symbols from the Insert Special Characters Add-On
Explain Your Formulas with Symbols

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.

Leave a Comment