EXcel 2007 and above
I have random value say, 3254.70 in cell A9
I want to extract only the decimal part, so, in cell B9 (can try either of the formula, as both yield same result)
both would bring the decimal value 0.7 or 0.70 BUT when i am testing it IN Cell B10, with IF formula, like =IF(B9=0.7,7,0), it shows false results, and returns 0 (return value on non fulfilling conditions)
I tried using VALUE function also which works with INT / TRUNC function (but not with TRUNC or MOD), 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.