Main Profile

At A Glance

Formulas in Excel 2 - Round Numbers to Next Lowest Integer in Excel Using the INT Function

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Use the INT() function in Excel to quickly round any number to the next lowest integer. This is a great little function in Excel to quickly change decimals to integers or numbers with decimals to only integers. Note though that this function will only round the the next lowest integer and it will not round up. View the ROUND() function tutorial to see how to round to the nearest integer going up as well as down. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Length: 02:15

Contact

Questions about Formulas in Excel 2 - Round Numbers to Next Lowest Integer in Excel Using the INT Function

Want more info about Formulas in Excel 2 - Round Numbers to Next Lowest Integer in Excel Using the INT Function? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question