Int, Fix Function
Returns the integer portion of a number.
Int(number)
Fix(number)
The number argument can be any valid numeric expression. If
number contains Null, Null
is returned.
Remarks
Both Int and Fix remove the fractional part of number
and return the resulting integer value.
The difference between Int and Fix is that if number is
negative, Int returns the first negative integer less than or equal to
number, whereas Fix returns the first negative integer greater
than or equal to number. For example, Int converts -8.4 to -9, and
Fix converts -8.4 to -8.
Fix(number) is equivalent to: Sgn(number) * Int(Abs(number))
The following examples illustrate how the Int and Fix functions
return integer portions of numbers: MyNumber = Int(99.8) ' Returns 99.
MyNumber = Fix(99.2) ' Returns 99.
MyNumber = Int(-99.8) ' Returns -100.
MyNumber = Fix(-99.8) ' Returns -99.
MyNumber = Int(-99.2) ' Returns -100.
MyNumber = Fix(-99.2) ' Returns -99.
|