Syntax
INT(number)
| Parameter | Description |
|---|---|
| number | Parameter of the INT function. |
Examples
Get whole number from decimal
Formula
=INT(7.85)
Returns: 7 — drops the decimal portion, keeping only the integer
Extract date from datetime
Formula
=INT(A2)
Returns: the date portion only — INT strips the time (decimal part) from a datetime value
Integer division (how many full boxes)
Formula
=INT(A2/12)
Returns: 4 — if you have 50 items and boxes hold 12, you can fill 4 complete boxes
Common Errors
#VALUE!
The argument is text. INT requires a number. Use VALUE() to convert text numbers first.
Tips
INT vs ROUND vs TRUNC
INT(3.7)=3, ROUND(3.7,0)=4, TRUNC(3.7)=3. INT and TRUNC differ for negatives: INT(-3.2)=-4, TRUNC(-3.2)=-3.
Extract time from datetime
=A1-INT(A1) gives the time portion (as a decimal). Format as Time to display as hours:minutes.
Remainder after INT division
Use MOD for the remainder: =MOD(50, 12) returns 2 (the 2 items left after filling 4 boxes of 12).
Try INT in Viztab
Import your data and use INT with 370+ other formulas. No signup required.
Open Viztab