What is meant by INT function in Microsoft Excel ?
BrindhaPrathaban Answered question June 30, 2023
Data
Formula
Description
Result
=INT(8.9)
Rounds 8.9 down
8
=INT(-8.9)
Rounds -8.9 down. Rounding a negative number down rounds it away from 0.
-9
=A2-INT(A2)
Returns the decimal part of a positive real number in cell A2
0.5
BrindhaPrathaban Answered question June 30, 2023
The int() function calculates the numerical integer equivalent of a specified phrase. int(num.exp) Number of parameters num.exp. The numeric integer equivalent of the expression is returned.
Vishalini.R Answered question June 30, 2023