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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | INT(number) |
| Google Sheets | ✔ Built in | INT(value) |
| Airtable | ✔ Built in | INT(value) |
| Notion | ✔ Built in | floor(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 ↗ |
| Airtable | INT(-7.9) | |
| Notion | floor(-7.9) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
number | The number to round down. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=INT(7.9) | 7 | ||
=INT(-7.9) | -8 | Down means toward −∞. | |
=A2-INT(A2) | Decimal part | Fractional part of a positive number (also the time part of a date-time). | |
=INT(NOW()) | Today as a serial | Strips 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.