VBA/Excel/Access/Word/Data Type/Int

Int(- returns -4

   <source lang="vb">

Sub mathDemo8()

  Debug.Print Int(-3.14159)

End Sub

</source>
   
  

Int(number) returns The integer portion of number (again, without rounding). If number is negative, returns the negative number less than or equal to number.

   <source lang="vb">

Sub mathDemo7()

  Debug.Print Int(3.14159)

End Sub

</source>
   
  

Int() Returns the integer portion of a number.

   <source lang="vb">

Sub mathF4()

   Debug.Print Int(-9.1)

End Sub

</source>