INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.
=INT(number)
number argument is the used to give value/cell reference that you want to round down to nearest integer.
Here, we have sample database and want to round down the sales movement ( % ) for various region.
We will be using INT function as follows:
Excel INT function is very simple and easy to use. This example will help you explore the use of the INT function in Excel.
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
COUNTBLANK function is used to get the total count of Blank or Empty cell in range.
COUNTBLANK Function has one required argument i.e. range.
TEXT function is used to change the formatting or appearances of the text. There are various types of formatting available.
Merge Cells in Excel Merge cells is to combine multiple cells into one cell which can further be used for giving title to the report or header to the column. It helps to create clean…
Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.
SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.