INT (Integer) Function in Excel |
My Digital Quill | Excel Formulas and Functions #27 | INT (Integer) Function in Excel | Excel tips and tricks | Excel #shorts
INT Function is math function in Excel that returns the integer part of a decimal number by rounding down to the integer. However, the negative numbers tend to move away from zero and rounds off to the next number away from zero. For example, while INT(10.8) returns 10, INT(-10.8) returns -11.
This example explains on how to use INT function for a simple problem whereby a range of number is given in one column. The INT( ) function in the corresponding column returns the integer value of the reference numeric expression and adjusts the value to an integer, whole-valued positive or negative number or 0.
Credits:
Thumbnail Photo by Justin Morgan on Unsplash
TrumpExcel
• INT Formula in Excel
Please check out more Excel tips and tricks from the playlist link down below:
• Excel Tips and Tricks
Check this playlist for Excel formulas and functions:
• Excel Formulas and Functions Series
Free Excel Course available on formatting techniques in here:
• Excel Formatting Techniques
🔔 Subscribe for free Office Tutorials at My Digital Quill:
/ @mydigitalquill8945
#intfunction #intfunctioninexcel #excelmathfunctions #Excelformulasandfunctions #Exceltipsand tricks #Excelshorts
#MyDigitalQuill
Смотрите видео INT (Integer) Function in Excel | онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь My Digital Quill 20 Февраль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 332 раз и оно понравилось 16 людям.