Determining an Integer Value

Summary: You can use the Int function, in a VBA macro, to return the integer portion of a value. This can be very handy in many types of data processing. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

VBA, true to its BASIC roots, provides a function to return the integer value of an expression. This means that anything to the right of the decimal point is truncated. Thus, if a formula would normally result in a value such as 18.73, then the integer value of that formula would result in 18.

The syntax for the integer function is as follows:

x = Int(y)

where x is the result and y is a value or an expression that evaluates to a value.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2352) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.

Check out ExcelTips Premium today!