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

Your Data, Your Way! Want the greatest control possible over how your data appears on the page? Excel's custom formats can provide that control, and ExcelTips: Custom Formats can unlock the secrets to creating your own custom formats.

Check out ExcelTips: Custom Formats today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Using the INT Worksheet Function