Data Type: Numeric
Any valid numeric expression.
The same data type as passed to the function containing only
the integer portion of
Removes the fractional part of a number. Operates in a similar way to the Int function.
Null, Fix returns
The operations of Int and
Fix are identical when dealing with
positive numbers: numbers are rounded down to the next lowest
whole number. For example, both
Fix(3.14) return 3.
number is negative,
Fix removes its fractional part, thereby
returning the next greater whole number. For example,
Fix(-3.667) returns -3. This contrasts
with Int, which returns the negative
integer less than or equal to number (or
-4, in the case of our example).
Dim dblTest Dim varTest dblTest = -100.9353 varTest = Fix(dblTest) ' returns -100 Msgbox varTest & " " & TypeName(varTest) dblTest = 100.9353 varTest = Fix(dblTest) 'returns 100 Msgbox.Print varTest & " " & TypeName(varTest)
Fix doesn’t round
number to the nearest whole number; it
simply removes the fractional part of
number. Therefore, the integer returned
by Fix is the nearest whole number less than
(or greater than, if the number is negative) the number passed to