Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
INT
INT returns the integer portion of a number by rounding down toward negative infinity. Unlike TRUNC, INT rounds negative numbers further away from zero (e.g. INT(-2.3) = -3). Use it to strip the decimal part of positive numbers or extract the day portion of a date serial.
Excel
=INT(A2)Google Sheets
=INT(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Value | Integer Part |
| 9.75 | |
| 3.14 | |
| 7.99 | |
| 0.5 |
=INT(A2)→9
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 is the number whose integer part you want (e.g. 9.75).
- 2INT rounds toward negative infinity, so 9.75 becomes 9.
- 3For negative values, INT(-2.3) returns -3, not -2 — use TRUNC if you want -2.