To extract Integer portion, one of the below can be used –
=INT(A1)
=TRUNC(A1)
Positive value in A1 – If A1 contains 84.65, then answer would be 84.
Negative value in A1 – If A1 contains -24.39, then answer would be -24.
If you want only +ve value whether value in A1 is -ve or +ve, the formula can have many variants.
=INT(A1)*SIGN(A1) OR =TRUNC(A1)*SIGN(A1)
=INT(ABS(A1)) OR =TRUNC(ABS(A1))
=ABS(INT(A1)) OR = ABS(TRUNC(A1))
To extract Decimal portion –
=MOD(ABS(A1),1)
=ABS(A1)-INT(ABS(A1))
Positive value in A1 – If A1 contains 84.65, then answer would be 0.65.
Negative value in A1 – If A1 contains -24.39, then answer would be 0.39.