Int, Fix function
Returns the integer portion of a number.
Int(number)
Fix(number)
The number argument can be any valid numeric expression. Returns nullIf the number parameter contains null.
Description
Both the Int and the Fix functions Delete the decimal part of the number parameter and return the result expressed as an integer.
The difference between the int and the Fix function is that if the number argument is a negative number, theint function returns the first negative integer less than or equal to number, and the The Fix function returns the first negative integer that is greater than or equal to the number argument. For example,Int converts 8.4 to 9, and the Fix function converts-8.4 to 8.
Fix (number) is equivalent to:
Sgn(numberInt(Abs(number))
The following example shows how the Int and Fix functions return the integer portion of a number:
mynumber = Int ( 99.8 ) '
return The
. MyNumber = Fix ( 99.2 ) '
return 99
. MyNumber = Int ( -99.8 ) '
return -100
. MyNumber = Fix ( -99.8 ) '
return -99
. MyNumber = Int ( -99.2 ) '
return -100
. MyNumber = Fix ( -99.2 ) '
return -99
.