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!
In an “IF function” there will be two output i.e. TRUE or FALSE since either the statement will be “TRUE” or “FALSE”. If the statement is matching or correct, then output will be “TRUE” or if the statement is not matching or not correct then the output will be “FALSE
COUNT function is used to get the total count of Number values in range or list.COUNT Function has one required and optional arguments.
ROWS function is used to get the total count of rows in an array or in cells range in an excel worksheet.
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
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.