INT
Name
Integer
Description
Rounds a specified number down to the nearest integer.
Syntax
INT(value)
Remarks
You can use the INT function to return the decimal portion of the value in a cell by subtracting the value of INT for the cell from the value in the cell, as illustrated in the first example.
The TRUNC and INT functions are similar in that both return integers. Use the TRUNC function to remove the decimal portion of the number; the TRUNC function does not round up or down. Use the INT function to round numbers down to the nearest integer-based decimal portion of the number.
The INT and TRUNC functions differ also when using negative numbers: TRUNC(-4.2) returns –4, but INT(-4.2) returns –5 because –5 is the lower number.
See also CEILING, EVEN, FLOOR, ODD, ROUND, ROUNDDOWN, ROUNDUP, and TRUNC.
Data Type
Accepts numeric data. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
R1C2-INT(R1C2)
INT(A3)
INT(2.85)=2
INT(-2.85)=-3