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
- 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