Using the INT Worksheet Function

Summary: The INT function allows you to convert a value to an integer. The effect the function has depends on the characteristics of the number it is converting. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

There are many times that you simply need to work with whole numbers. Excel provides a handy function, INT, for just such times. This function takes a single argument and returns the integer value of that argument. For instance, consider the following:

=INT(12.34)

Using this formula, Excel returns a value of 12. You should be aware that INT always returns the next lower whole integer. This only seems odd when dealing with negative numbers. For instance, consider the following:

=INT(-43.21)

You may be tempted to believe that Excel would return a value of –43, but this would be wrong. When following the rule of always returning the next lower whole integer, Excel would return –44, which is the next integer lower than -43.21.

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

Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.

Check out ExcelTips: Times and Dates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Using the INT Worksheet Function