Fix Function

Syntax:

Fix(Num)

Group:

Math

Description: Returns the integer value.

Parameters:

Parameter

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:

Int