I have value 3259.90 in cell AD9
I want to extract only the decimal part, so, i am using formula in cell AF9
=AD9-TRUNC(AD9)
or
=MOD(AD9,1)
both would bring the decimal value 0.9 or 0.90 BUT when i am testing it with IF formula, like =IF(AF9=0.9,9,0), it shows false results, and returns 0 (return value on non fulfilling conditions)
I tried using VALUE function also, but no desired result. What formula i should use to get only decimal value, and test it with IF function, to ensure certain other work.
Bookmarks