Visual Basic Scripting Edition Int, Fix Functions
Requirements
Version 1 [This topic is part of a beta release and is subject to change in future releases. Blank topics are included as placeholders.]
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.
Requirements
Version 1 See Also
CInt Function | Round Function
--------------------------------------------------------------------------------
© 2001 Microsoft Corporation. All rights reserved. |