# Excel-VBA/Formula : Math Functions – INT()

Descrip­tion: The INT() func­tion in MS excel returns the Inte­ger part of a number

NOTE: If the num­ber is neg­a­tive, INT() will return the first neg­a­tive num­ber less than equal to the given number.

Read about Excel-VBA : FIX() If the num­ber is neg­a­tive, and you want the first neg­a­tive num­ber greater than equal to the given number.

For­mat:

VBA Func­tion : INT(number)

Excel For­mula : INT(number)

Argu­ments:

• Num­ber
• Manda­tory
• Type: num­ber
• num­ber for which inte­ger part will be returned

Cases:

 55.11 55 –220 –220 –22.38 –23 –50.9 –51

Exam­ple:

```Function getINT()
val1 = 10.2
val2 = 33.9
val3 = -22.2
val4 = -10.9
strResult = "The INTEGER part of " & val1 & " is " & Int(val1) & vbCrLf
strResult = strResult & "The INTEGER part of " & val2 & " is " & Int(val2) & vbCrLf
strResult = strResult & "The INTEGER part of " & val3 & " is " & Int(val3) & vbCrLf
strResult = strResult & "The INTEGER part of " & val4 & " is " & Int(val4) & vbCrLf
MsgBox strResult
End Function
```

INT-VBA

As Excel Formula:

INT — Formula