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!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• int() function
• round integers in excel
• round numbers in excel
• number manipulation in excel
• Tutorial
• Software
• Technology

[s0cialdelinquant]

anyone know how to stop the stupid program from rounding down

[f2res]

Thank's