Article updated on April 17, 2018

Removes the decimal part from positive numbers and returns the whole number (integer) except negative values are rounded down to the nearest integer.

Example, -6.1 is rounded down to -7.

Formula in cell C3:

=INT(B3)

Excel Function Syntax

INT(number)

Arguments

number Required. The number you want to convert to an integer.

Comments

Boolean values are converted into their equivalent integer. TRUE is 1 and FALSE is 0.