Fix

Returns the integer portion of a number.

Structure

Fix(number)

Parameters

The number argument can be any valid numeric expression.

Description

If number contains Null, Null is returned.

Fix removes the fractional part of number and returns the resulting integer value.

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:

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

Example

The following examples illustrate how the Fix function returns integer portions of numbers:

MyNumber = Fix(99.2) ' Returns 99.

MyNumber = Fix(-99.8) ' Returns -99.

MyNumber = Fix(-99.2) ' Returns -99. |