Wednesday 4 November 2009

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

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


Video:


Description:Visit 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 There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
05/Nov/2009

No comments:

Post a Comment