INT (Integer) Function in Excel |

Published: 20 February 2022
on channel: My Digital Quill

332

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 without registration, duration hours minute second in high quality. This video was added by user My Digital Quill 20 February 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 332 once and liked it 16 people.

292