INT Function in Excel – Round down to the nearest integer

The INT Function in Excel round downs a supplied number to the nearest integer

Syntax of INT Function in Excel

INT( number)

Number – value to be rounded down to the nearest integer

Example of INT Function in Excel

Formula

INT Function in Excel 1

In Row number 2, the value 3.2 is rounded down to 3
In Row number 3, the value 0.01 is rounded down to 0
In Row number 4, the value -0.01 is rounded down to -1

So the result will be

Result

INT Function in Excel 2