Fix Function
Syntax
Fix(Num)
Group
Description
Return the integer value.
Parameters
Parameters | Description |
---|---|
Num | Return the integer portion of this numeric value. The number is truncated. Positive numbers return the next lower integer. Negative numbers return the next higher integer. If this value is Null then Null is returned. |
Example
Sub Main Debug.Print Fix(9.9) ' 9 Debug.Print Fix(0) ' 0 Debug.Print Fix(-9.9) '-9 End Sub
See also