See Also Example
Return the integer portion of a number.
Syntax
Int(number)
Fix(number)
Remarks
The argument number can be any valid numeric expression Both Int and Fix remove the fractional part of number and return the resulting integer value.
The data type However, if number is a Variant of VarType 8 (String) that can be converted to a number, the return type will be a Variant of VarType 5 (Double). If the numeric expression results in a Null , Int and Fix return a Null.
The difference between Int and Fix is that if number is negative, Int returns the first negative integer less than or equal to number, whereas Fix returns the first negative integer greater than or equal to number. For example, Int converts -8.4 to -9, and Fix converts -8.4 to -8.
Fix(number) is equivalent to:
Sgn(number) * Int(Abs(number))
Data Type Conversion Functions
Math Functions
Int Function, Fix Function Example
The example illustrates the difference between Int and Fix. To try this example, paste the code into the Declarations section of a form. Then press F5 and click the form.
Sub Form_Click ()
Dim Msg, NL, TB ' Declare variables.
NL = Chr(13) & Chr(10): TB = Chr(9) ' Define newline, tab.
Msg = "Int(-99.8) returns" & TB & Int(-99.8)
Msg = Msg & TB & "Fix(-99.8) returns" & TB & Fix(-99.8)
Msg = Msg & NL & "Int(-99.2) returns" & TB & Int(-99.2)
Msg = Msg & TB & "Fix(-99.2) returns" & TB & Fix(-99.2)
MsgBox Msg ' Display message.
End Sub