Author: Oscar Cronquist Article last 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.