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
Watch video INT (Integer) Function in Excel | online, duration hours minute second in high quality that is uploaded to the channel My Digital Quill 20 February 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 332 times and liked it 16 visitors.
