INT (Integer) Function in Excel |

Published: 20 February 2022
on channel: My Digital Quill
332
16

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.