Spreadsheet formulas explained, side by side

INT Function in Excel, Google Sheets, Airtable & Notion

INT returns the integer part of a number by rounding down toward negative infinity, so INT(7.9) is 7 and INT(−7.9) is −8.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inINT(number)
Google Sheets✔ Built inINT(value)
Airtable✔ Built inINT(value)
Notion✔ Built infloor(number)
Try INT with your own values
Result (as Excel & Google Sheets return it)
-8
Your formula, ready to paste
Excel=INT(-7.9) open excel.new ↗
Google Sheets=INT(-7.9) open sheets.new ↗
AirtableINT(-7.9)
Notionfloor(-7.9)

Arguments

ArgumentWhat it means
numberThe number to round down.

Examples

FormulaResultWhyCopy
=INT(7.9)7
=INT(-7.9)-8Down means toward −∞.
=A2-INT(A2)Decimal partFractional part of a positive number (also the time part of a date-time).
=INT(NOW())Today as a serialStrips the time from a date-time.

Examples use Excel / Google Sheets syntax unless noted.

How INT works

INT is often used with dates: Excel and Google Sheets store date-times as a serial day number plus a fraction of a day, so =INT(A2) keeps only the date and =A2-INT(A2) keeps only the time.

The gotcha is negative numbers. INT always rounds toward negative infinity, so −7.9 becomes −8, not −7. If you want to simply drop the decimals use TRUNC or ROUNDDOWN(x, 0). In Notion the equivalent function is floor(), which behaves exactly like INT.

Frequently Asked Questions

How do I get the decimal part of a number?
For positive numbers use =A2-INT(A2), or =MOD(A2, 1). For negatives, =A2-TRUNC(A2) keeps the sign.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.