INT(Number), where Number is a real number that needs to be rounded down. The so-called "rounding down" means that when calculating, if the calculation result is not an integer, the integer less than the calculation result is inverted, and "rounding up" means that when the calculation result is not an integer, the integer greater than the calculation result is taken. Rounds a number down to the nearest integer.
Extended data
Given a positive integer, if you divide it by 100, will the remainder be greater than 50? If it is greater than or equal to 50, round the quotient with the int function (note that the int function has the feature of rounding down), and add 1 to get the result of multiplying by 100. If the remainder is less than 50, round the quotient with int function and multiply it directly by 100.
The Int function is a rounding function and the syntax is int (number). This function will round down the numbers in parentheses, such as int (6.9) = 6 and int (-6.9) =-7.
Mod function is a remainder function, its syntax is mod (number, divisor), and the function will process the remainder of quotient. Note that when the number is negative, the result of the same divisor may be different. Please refer to the help of mod function in Excel for details.
Baidu Encyclopedia -INT () function