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>