Fix Function

Syntax

Fix(Num)

Group

Math

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

Int