Fix

This function removes the fractional part of a number and return the resulting integer.

Syntax

Fix(number)

Parameters

number

Any valid numeric expression. If number contains Null, Null is returned.

Return Values

Returns an integer.

Remarks

If number is negative, Fix returns the first negative integer greater than or equal to number. For example, Fix converts –8.4 to –8.

Fix(number) is equivalent to the following line of code.

Sgn(number) * Int(Abs(number)Int)