Name
Fix Function
Syntax
Fix(number
)
-
number
Use: Required
Data Subtype: Numeric
Any valid numeric expression.
Return Value
The same data subtype as passed to the function containing only the
integer portion of number
.
Description
Removes the fractional part of a number. Operates in a similar way to
the Int
function.
Rules at a Glance
If
number
isNull
,Fix
returnsNull
.The operations of
Int
andFix
are identical when dealing with positive numbers: numbers are rounded down to the next lowest whole number. For example, bothInt(3.14)
andFix(3.14)
return 3.If
number
is negative,Fix
removes its fractional part, thereby returning the next greater whole number. For example,Fix(-3.667)
returns -3. This contrasts withInt
, which returns the negative integer less than or equal to number (or -4, in the case of our example).
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)
Programming Tips & Gotchas
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 the
function.
See Also
Int Function, CInt Function, CLng Function, Round Function |
Get VBScript in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.