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

Number – value to be rounded down to the nearest integer

 

Example of INT Function in Excel

Formula

• 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