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