=INT(number)
number argument is the used to give value/cell reference that you want to round down to nearest integer.
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!
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.
CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.
INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.
Excel Function COUNTIF COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You…
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
SUBSTITUTE function is used to substitute the existing old text to new text.