Article updated on January 29, 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:


Excel Function Syntax



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


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