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:


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.