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

Don't Go in Debt for Christmas! Tired of trying to keep up with the Joneses for Christmas? Want to enjoy the season rather than dread the aftermath? Learn how you can avoid the financial traps that spring up every Christmas.

Check out Top Fifteen Tips for Financing Christmas today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Using the INT Worksheet Function