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

previous-small INT Function in Excel                                                                                                          next_small INT Function in Excel