Excel VBA INT Function
VBA INT Function: The INT function in VBA rounds the given supplied number down and returns an integer value. The positive numbers are rounded to zero, and the negative numbers are rounded away from zero.
Syntax
Int (Number)
Parameter
Number (required) –This parameter represents the number that you want the integer value of.
Return
This function returns the rounded off integer value for the supplied number.
Example 1
Sub IntFunction_Example1() ' Rounding a positve number towards 0 Dim int_val As Integer Dim int2 As Integer int_val = Int(12.78) ' The variable int_val will return 12 Cells(1, 1).Value = int_val End Sub
Output
12
Example 2
Sub IntFunction_Example1() ' Rounding a negative number away from 0 Dim int_val As Integer Dim int2 As Integer int_val = Int(-12.78) ' The variable int_val will return -13 Cells(1, 1).Value = int_val End Sub
Output
-13
Example 3
Sub IntFunction_Example3() Dim int_val As Integer Dim int2 As Integer 'for other formats apart from number int_val = Int("Hey") ' The variable int_val will return run time error Cells(1, 1).Value = int_val End Sub
Output