| Int Function |
Named Arguments
No
Syntax
Int(number)
number
Use: Required
Data Type: Any valid numeric data type
The number to be processed.
Return Value
Returns a value of the data type passed to it.
Description
Returns the integer portion of a number.
Rules at a Glance
The fractional part of number is removed and the resulting integer value returned. Int doesn't round number to the nearest whole number; for example, Int(100.9) returns 100.
If number is negative, Int returns the first negative integer less than or equal to number ; for example, Int(-10.1) returns –11.
Programming Tips and Gotchas
Int and Fix work identically with positive numbers. However, for negative numbers, Fix returns the first negative integer greater than number. For example, Int(-10.1) returns –10.
Don't confuse the Int function with CInt. CInt casts the number passed to it as an Integer data type, whereas Int returns the same data type that was passed to it.
See Also
- Fix Function
Get VB & VBA in a Nutshell: The Language 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.
