Returns the nearest integer value that is less than or equal to a number.
Int ( numExpr )
numExpr
Any numeric expression.
The data type of numExpr determines the data type of the value returned by the Int function. The following table shows special cases.
numExpr |
Return value |
---|---|
NULL |
NULL |
Variant containing a string interpretable as a number |
Double |
The value returned by the Int function is always less than or equal to its argument.
The Fix function and the Int function behave differently. Fix removes the fractional part of its argument, truncating toward 0.